1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysql backup software

Discussion in 'HTML, Graphics & Programming' started by Nate, 25 May 2006.

  1. Nate

    Wise Guy

    Joined: 18 Oct 2002

    Posts: 1,581

    Location: Nottingham

    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!
     
  2. Beansprout

    Man of Honour

    Joined: 31 Jan 2004

    Posts: 16,326

    Location: Plymouth

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

    Wise Guy

    Joined: 18 Oct 2002

    Posts: 1,581

    Location: Nottingham

    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?
     
  4. Beansprout

    Man of Honour

    Joined: 31 Jan 2004

    Posts: 16,326

    Location: Plymouth

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

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

    Wise Guy

    Joined: 19 Oct 2003

    Posts: 1,112

    Location: Olympia, WA, USA

    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.
     
  6. Dfhaii

    Hitman

    Joined: 19 Oct 2002

    Posts: 550

    Location: Penryn

    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.
     
  7. Beansprout

    Man of Honour

    Joined: 31 Jan 2004

    Posts: 16,326

    Location: Plymouth

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

    Hitman

    Joined: 19 Oct 2002

    Posts: 550

    Location: Penryn

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

    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