Miscellaneous ramblings of a web developer called David Parkinson. I work full time as a web developer but have interests in other things.
In my daily job of web development i sometimes come to a grinding halt when a task i have to do requires a bit of tinkering. A week or two ago i had the task of moving a large mySQL Database from one server to another, and what a pain it was.
First of all the size of this database was roughly 80MB, secondly the server only allowed a max upload of around 2MB via phpMyAdmin so i thought how the hell am i going to get this across. I did some research, looked on forums and basically searched Google for the answer and to be honest i didn’t find the answer until i ran into what looks like the best script to do the exact task.
BigDump did the job for me. I had the database moved across within the next hour, was happy and immediately bookmarked the site. If you are having trouble moving a database across due to hosting restrictions i highly recommend taking a look at BigDump.
To restore the very large backup of your mySQL database (or a part of it) into the new or the same mySQL database. You can’t access the server shell and you can’t import the dump using phpMyAdmin or any other scripts due to hard memory resp. runtime limit of the web server.
It does exactly what it says on the tin. All you need to do is export the database from phpMyAdmin, upload the database to the same directory as bigdump.php, run the script and Kudos! You’ve imported a large database without any hassle.
If anyone has found any other scripts worth taking a look at, please let me know.
