How to backup + restore large databases?

GaryW

Active Member
Apr 27, 2004
31
0
156
Using the cpanel method sucks because it crashes my browser when I try restoring large databases since it outputs the entire input file to my browser, and I don't have SSH access.

Any other methods to backup and restore?
 

chirpy

Well-Known Member
Verifed Vendor
Jun 15, 2002
13,441
31
473
Go on, have a guess
Another option is to use phpmyadmin and make sure that you select:

Save as file
zipped

Since most MySQL data is text it should compress down nicely, and you will then e presented with a file to download. You can also restore a zipped file through phpmyadmin.
 

LiquidAtoR

Member
Nov 28, 2004
6
0
151
Try the attached file.
Unpack it and upload it to your webdirectory.

Set the variables in tool_settings.php to match your data of the database and set a password if you intend to keep the file on your server in mysql_tool.php.

Upload your database.sql in the same folder.

Open mysql_tool.php trough your webbrowser and follow online instruction on how to restore the database.

Basicaly this tool enables you to restore large databases without the timeout you will receive trough php (e.g. phpMyAdmin).
It cuts your database in little pieces and processes them, taking the next step where it left off the last time (it counts in %)

At the end you get restoration complete, and the whole database is back in place.
I've done this with databases over 200 MB without any problems.

Good luck, Mike.
 

Attachments

sawbuck

Well-Known Member
Jan 18, 2004
1,365
10
168
cPanel Access Level
Root Administrator
Have taken the liberty of re-attaching the file originally posted by LiquidAtoR as the recent forum server change corrupted the avatars but also apparently previously attached files.
 

Attachments