How to backup + restore large databases?

[GaryW]

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?

 

[sawbuck]

You may want to look at this: http://restkultur.ch/personal/wolf/scripts/db_backup/index.html

 

[chirpy]

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]

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.

 

[FWC]

Do it from the command line:

mysql -u dbusername -p dbname < /path/to/backup.sql

 

[LiquidAtoR]

Do it from the command line:

and I don't have SSH access.

He doesn't have shell access, so most likely no command line
That's why he asked for alternatives to restore a large database.

 

[sawbuck]

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.