When migrating a site that has been around for a while, I often run into the problem where my MySQL Database is just too large to import via the web interface of PHPMyAdmin. Often times its to a server that doesn't allow remote access to their databases. What is a poor dev to do?
* Download the latest version of Big Dump <a href="http://www.ozerov.de/bigdump.zip" target="_blank">here</a>. * Open up bigdump.php and configure: Server, database name, username, password, and the file name. * Upload both your SQL file and bigdump.php to your server * Browse to bigdump.php and click import
Thats it! Wait a few minutes and you will see a confirmation screen similar to the one below. Make sure to delete bigdump.php off your server when you are finished.
Find an issue with this post? Think you could clarify, update or add something?
All my posts are available to edit on Github. Any fix, little or small, is appreciated!