Automating MySQL Backups???

Discussion in 'MySQL' started by jawinn, Aug 21, 2006.

0
  1. #1
    I have a hosted site at GoDaddy running MySQL. Does anyone know how to automate backing up this DB? Are there any free scripts out there that can backup DBs? I have servers to copy the file to, I just don't know how to do actual automation.

    thx
     
    jawinn, Aug 21, 2006 IP
  2. Golfboards

    Golfboards Peon

    Messages:
    122
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I use this one: http://sourceforge.net/projects/automysqlbackup/

    ... and it works pretty well. But, if you just google for "mysql backup script" you'll find hundreds of them. They all (for the most part) use the mysqldump utility that comes with your MySQL installation.

     
    Golfboards, Aug 21, 2006 IP
  3. brandnewx

    brandnewx Peon

    Messages:
    988
    Likes Received:
    28
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I was wondering why mysql community isn't interested in xcopy backup. One of the critical feature is overlooked. For MS-SQL 2005 db, you can just copy the db file like ordinary file; you don't need to lock and flush the tables and dump them to file.

    Anyway, for small mysql databases, mysqldump will work just fine. When db gets big in GBs, you'll need to replicate the db in another server. You'll then get real-time backup.
     
    brandnewx, Aug 21, 2006 IP
  4. Alis

    Alis Peon

    Messages:
    1,787
    Likes Received:
    159
    Best Answers:
    0
    Trophy Points:
    0
    #4
    If you use cpanel , in the backup for db's section its automated..
     
    Alis, Aug 21, 2006 IP