BigDump: Alternative to phpMyAdmin to Import/Restore Large Database

Recently I was facing problem on restoring database with a lot of data into MYSQL using phpMyAdmin. The restoring process keeps interrupted due to the connection between browser and server time’s timeout and also due to the timeout in PHP script. Only partial data is restored and I kept dropping the database, increase PHP timeout, increased memory limit, and tried to restore again. But it still failed.

Then, I found a very useful, free script BigDump which helps me to solve my problem. The way it work is pretty simple. It simply split the dump data into a few parts and execute it one by one. The script remembers where is the point it ups to in session, execute a portion of data, and then restart itself to continue to process the un-process data.

If you are having problems importing or restoring huge data into MYSQL using phpMyAdmin, you can try using this script. You can either upload your MYSQL dumps from the script page or point it to the MYSQL dumps located in your server.

Download BigDump (about 10kb)