Tool for scheduled mySQL backups?

Discussion in 'MySQL' started by flOid, Jan 31, 2006.

0
  1. #1
    Is there any free tool with a web based front-end that can do scheduled mySQL backups? I'm not talking about something like PHPmyAdmin, I mean something with a simular front-end, but which can be scheduled and is ran by cron job, so it can be ran automatically, and can also be used for large databases, so you don't get a script timeout.
     
    flOid, Jan 31, 2006 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    digitalpoint, Jan 31, 2006 IP
  3. flOid

    flOid Active Member

    Messages:
    119
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    58
    #3
    Thanx! But this is for binary backups, right? I'm looking for something that can do mysqldumps. sorry, should have said this from the beginning...
     
    flOid, Jan 31, 2006 IP
  4. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #4
    digitalpoint, Jan 31, 2006 IP
  5. alejandroarauz

    alejandroarauz Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Here is an example of the mysqldump command, you can create an scheduled task or a cron job to run the task automatically.
    mysqldump --opt --host=localhost --user=myUser --password=myPass --result-file=C:\Backups\myBackupFile.sql myDatabase

    If you are looking for a tool you could try MySQLBackupFTP,this tool connects to MySQL through phpMyAdmin. Though the tool is not free, it has a free version that allows you to schedule up to two databases. The tool allows you to configure a temporary folder and set timeout settings for large databases.
     
    alejandroarauz, Nov 3, 2011 IP