Importing Large MySQL Databases

You can’t import an SQL database larger than 2 MB using PHPMyAdmin. So what do you do? There is a script called bigdump.php that you can download, edit and upload that will automatically import your database no matter how big.
This is what you do:
1. Export your database from the site’s current location to a database.sql file.
2. Download bigdump.php from />3. Edit bigdump.php by adding the destination MySQL database name, location and password, as well as the name of the .sql file that you want to import.
4. Create a directory on the new host called dump, and upload the .sql file and bigdump.php into that directory.
5. In your browser, run />Test your site; should work just fine.