mysql backup software

[Nate]

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]

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

 

[Nate]

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]

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]

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]

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]

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]

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