phpMyAdmin has a upload restriction, normally allocated to 50mb, which causes issues when you want to import databases larger than that. You can bypass this by importing your databases in chunks but can get time-consuming if you are working with large databases. You can overcome this by using a program/script called BigDump which will allow you to import larger databases larger than 50Mb.

How to use BigDump:

• Download BigDump here
• Make sure you have a copy of the Database in a .sql or .gz format, also make sure when you export the database that you include the “drop table” function and turn off “extended inserts”
• Upload bigdump.php to your package
• Open bigdump and update your database details to your own :

1. $db_server = ‘localhost’; //This is usually localhost
2. $db_name = ‘database_name’; //Your database name
3. $db_username = ‘database_username’; //Your database username
4. $db_password = ‘password’; //Your database password

• Upload the file to your website content
• Upload the database in the same directory as the bigdump.php file
• Go too http://yourwebsite/bigdump.php
• Select the file you wish to import from the list bigdump creates
• Wait for it to finish
• Once you are finished delete bigdump and the database file from the uploaded directory

If you keep getting a timeout error when BigDump runs an import, try increasing the $linespersession in the bigdump file.