mysql backup software

Nate · 25 May 2006 at 15:29

I have been using mySQL adminstrator tool to backup databases so far and it has worked well, but we have just got a new webserver and it has mysql version 3.x and the software only supports 4.0.

Does anyone know of any decent software out there to use for backups. Free if possible always helps!

Beansprout · 25 May 2006 at 15:34

Upgrade MySQL....version 3 is as old as, well, you don't want to use it :eek:

Nate · 25 May 2006 at 15:58

i think that would probably be for the best, as i havent had a chance to use a web server before it would be good to find out how to do this. Does anyone have any links to good guides on how to do it?

Beansprout · 25 May 2006 at 16:13

I'd slap your provider silly for giving you MySQL 3 personally

There's an upgrade guide on the MySQL site here. Specifics of upgrading will depend on your server setup

nomore · 29 May 2006 at 00:03

SSH into the server, then type...

mysqldump -u user -ppassword dbname > filename

e.g.

mysqldump -u root -procknroll mydatabase > ~/Desktop/mydatabase.sql

Stick this into a shell script... then you're set... use Cron to run it automatically.

Dfhaii · 29 May 2006 at 00:46

if it's going in a public directory then it probably wouldn't be a bad idea to encrypt the data file.

I have a script cronned which does a mysql_dump, then runs that through gpg, and a script cronned on my home machine to wget a copy off, makes for a nice secure automated backup.

Beansprout · 29 May 2006 at 00:48

Dfhaii said:
if it's going in a public directory then it probably wouldn't be a bad idea to encrypt the data file.

I have a script cronned which does a mysql_dump, then runs that through gpg, and a script cronned on my home machine to wget a copy off, makes for a nice secure automated backup.

Why not just put it in ../[web root] and (S)FTP/SCP

Dfhaii · 29 May 2006 at 18:37

Mainly because I didn't think of that at the time

That said I can't really see a problem with how I'm doing it now, yes other folk can download my data, but without my private key, and password there isn't a whole lot they can do with it.

Col