Recommend an auto backup tool for MySQL?

Forum Moderators: open

Message Too Old, No Replies

Recommend an auto backup tool for MySQL?

running on a remote host

httpwebwitch

4:45 am on Mar 14, 2008 (gmt 0)

I have a whole bunch of mySQL databases running on a remote host, on a rented server. Currently I back it up every few days manually using SQLYOG. (it takes about half an hour to export them all, which is a real drag).

I'd like this to be done automagically, nightly. Using a cron, or maybe a Windows scheduled task?
Can anyone recommend software to do this?

I've found a few options online but I can't tell a good one from a lousy one without trying them all.

Oh, and my favourite price point is $0, though if there's a small cost for great value, I'll pay up. Don't MySQL/PHP people do everything for free?

Lexur

6:59 am on Mar 14, 2008 (gmt 0)

I've found a few options online

Please, spread your light :)

Nutter

12:41 pm on Mar 14, 2008 (gmt 0)

I've got mysqldump running as a cron job on my local file server to backup from my web server. You should be able to do something similar by installing MySQL on your computer and setting up a scheduled task.

httpwebwitch

2:49 pm on Mar 14, 2008 (gmt 0)

Lexur=>

Please, spread your light

Well, a GOOG search for "backup mysql" turned up a dozen options, most are just scripts you'd run on a daily cronjob.

Here is one such:

mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]

and another:

mysqldump --all-databases> alldatabases.sql

Maybe I'm being a weenie but I'd prefer something with a friendly GUI interface and pretty status messages and progress bars, saving the *.sql file to my local C: drive, rather than saving to my web server.

Lexur

6:50 am on Mar 15, 2008 (gmt 0)

I think exactly the same way.

I like to have some hard copies of everything in two mirrored
a) CD's (some years ago)
b) portable 2.5' USB disks (1 year ago)
c) 8 GB pendrives now

I make the database copies from the server every saturday (ooops... today I must do it) but I feel uncomfortable with the fact that all of my databases are live and changing for a whole week and I can lose these contents.

I'll wait for this thread but if there is no anything useful and with pretty progress bars, maybe we should thing about to make the backups to servers from other companies/datacenters.

DrDoc

7:05 am on Mar 15, 2008 (gmt 0)

I use

mysqldump

and then copy/move the files to a backup location using scp/ftp/mounted drives/whatever ...

It provides for easy recovery.

A few things to think about: don't dump everything. Dump in batches that are as small as possible. That way partial recovery is much quicker and easier. Also, it seems to put less strain on the server.