As a website owner or blogger you may want to import your MySQL dump from one server to another server database, but what you do if it exceeds the limit offered by phpMyAdmin. By default phpMyAdmin provides the upload limit specified in the php.ini file. You can increase this upload limit size by editing the php.ini file if you have access to it, generally if you are in a shared hosting you won’t be able to edit this file becoz it will effect all the accounts on that server and your webhost won’t allow this. If you have shell access to your account you can import easily, see below for how to import using SSH
BigDump is a script written by Alexey Ozerov for importing large mysql dumps. It’s a staggered MySQL dump importer, meaning the script executes only small part of the huge dump and restarts itself, the next session starts where the last was stopped. This process continues until it imports the whole database dump.
First you need to export your dump using phpMyAdmin, you can select the options like ‘Add DROP TABLE’, ‘Add IF NOT EXISTS’, if you plan to overwrite an existing database. Remember not to select ‘Extended Inserts’ while creating dump, if you select this option BigDump will fail. After creating the dump upload it to your server using your favorite FTP, download bigdump script and set the values like username, password, db name etc and upload it to the server. Now execute the script by pointing your browser to the bigdump.php file (ex: http://www.yourdomain.com/dump/bigdump.php). The file takes sometime to complete if you are importing a large database, be patient. Once it imports the dump successfully it will show you a message.
I had imported a database of size 160MB using this script, above this size i nevr tried but it should work properly.
If you have shell acess you can use the following commands to dump your mysql database.
mysql -u [user] -p [password] -h [hostname] [databasename] <[file.sql] Download BigDump