[RESOLVED] 56MB table - backup and restore

sarahk

I have a huge stats table that I need to backup prior to a software upgrade and to move to a new database.

phpMyAdmin is taking the site down with "too many connections".

Any recommended tools for doing this some other way?

bogu

Did u try from CPANEL, the backup section?

sarahk

The server doesn't use cpanel and I need to save onto the server I reckon.

bogu

But do u have ssh connection?
Phpmyadmin it wont help u with such big database ...

sarahk

I wish

I've written a script to connect to both databases and query one and recreate the inserts for the other

MarkR

You should use mysqldump to backup the database. This is the ONLY tool which will do it correctly. Forget cpanel, forget PHPMyAdmin, they are all horribly broken and will make hideous mistakes.

In any case, you should be making regular backups of your database (if this is a production site). Use the same system as you use for your scheduled backups.

Obviously disable the web site before taking the backup so that nobody can enter any new data in the interim.

Read the MySQL documentation for more info about how to (correctly) use mysqldump and mysql to backup and restore the db.

Mark

sarahk

Quite right Mark, and my client is doing backups of all the databases. However in this case I wanted to move part of one database into another database and that proved a bit tricky.