phpmyadmin problem

[amber.long]

hello everyone

I have exported 20 mb sql file with phpmyadmin and when i trying to import that file with phpmyadmin it shows me this error

You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.

any one can please give me suggestion how can i solve this error?

thanks in advance

[Riverwire]

Yeah this happens quite alot , just submit a ticket to your host and ask them to upload it for you , they will do it no problem

[amber.long]

Thanks for help

[RDragos]

You can also try to divide the file, and import it separately.

[midlandi]

Simplest is to use BigDump to import a big database:
http://www.ozerov.de/bigdump.php

MySQLDumper is an alternative too, which also can be used for big backups with time out issues:
http://www.mysqldumper.de/en/

[webtalk]

you can export large file with phpmyadmin, you can export it via ssh

login via ssh
than
mysql -u user -p databasename tableiftable < /path/to/dump

cheers

[midlandi]

you can export large file with phpmyadmin, you can export it via ssh

login via ssh
than
mysql -u user -p databasename tableiftable < /path/to/dump

cheers

Trouble is that alot of providers no longer allow ssh access on shared accounts.

[webtalk]

Trouble is that alot of providers no longer allow ssh access on shared accounts.

they will allow you if you have static ip, else you have to contact with your host to import

[expertsweb]

create custom php.ini in your root directory and add
post_max_size = 100M and upload_max_filesize = 100M