Back to Management Articles

Restore any size SQL backup using phpMyAdmin
by Zylantex 19 Aug 2011

The biggest problem with restoring a sql backup is hitting the php timeout wall.

There is a way around this and it's incredibly simple.

You just need a tool to break your backup into intelligent chunks which are small enough not to timeout during the restore process.

This is done using http://www.mediafire.com/file/wrc42isljbwplbs/SQLDumpSplitter.zip.

The procedure is simple:

1. Create a holding directory called say "Split Files" on your desktop.
2. Unzip and run SqlDumpSplitter.exe
3. Select your backup file
4. Set the maximum file size you want to work with say 10240 KB ( I have used 30000 KB sucessfully)
5. Set the target directory that you created in Step 1
6. Click the word Execute.

The program will create a sub folder in your target directory called SQLDumpSplitterResult.

The split files will be found there one of which will have a filename ending in DataStructure.sql.

The rest will be named the same as your original backup file with a numerical sequence identifier added.

Now you are ready to use phpMyAdmin to import your backup.

I would strongly advise against attempting this process unless you are comfortable with phpMyAdmin.

Import the file ending in DataStructure.sql first as this recreates your file structure, tables etc.

Import the other files in the directory one at a time in numerical order.

Don't be impatient as the process is limited by your upload speed.

If for any reason the process does timeout simply restart the whole process and pick a smaller file size in Step 4.

You the must recommence the phpMyAdmin process completely from scratch including the import of the first file ending in DataStructure.sql

That's about all there is to it.

Regards,

Zylantex

*** Full credit must be given to Philip Lehmann-Böhm http://www.philiplb.de/ who wrote this great tool. ***
Attached Thumbnails
Click image for larger version
Name:	SQLSplitter2.JPG
Views:	66
Size:	35.1 KB
ID:	132124  

vblts.ru supports vBulletin®, 2022-2024