Setting uUp db Backup Solution

Discussion in 'Programming' started by trt123, Jun 10, 2013.

0
  1. #1
    Hi.

    I need a free GOOD utility that I can upload to my server that will back up my database ever 5 or 10 minutes by overwriting the last previous backup so that I don't end up with thousands of sql files.

    Anyone know of any good solution?
     
    trt123, Jun 10, 2013 IP
  2. socialappzone

    socialappzone Member

    Messages:
    27
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    31
    Digital Goods:
    1
    #2
    This is very easy, the tools for this are already on your server

    1. You need to setup a cron job to do your backup. Info on this here:

    https://en.wikipedia.org/wiki/Cron

    2. Get the Cron to run a database backup every 5 or 10. It will overide the previous one

    For MySql use mysqldump
     
    socialappzone, Jun 10, 2013 IP
  3. sarahk

    sarahk iTamer Staff

    Messages:
    28,838
    Likes Received:
    4,542
    Best Answers:
    123
    Trophy Points:
    665
    #3
    I use the tools that come with sqlyog (which is not free). Worth every penny - especially if you are backing up that often.
     
    sarahk, Jun 11, 2013 IP
  4. GORF

    GORF Well-Known Member

    Messages:
    224
    Likes Received:
    21
    Best Answers:
    3
    Trophy Points:
    165
    #4
    If you keep only one copy and overwrite it that often, what happens when it actually crashes or breaks? Will you be able to get to it and fix it within 10 minutes? No. All you will have is one broken copy.

    Keep multiple copies spaced out in time.
     
    GORF, Jun 11, 2013 IP
  5. sarahk

    sarahk iTamer Staff

    Messages:
    28,838
    Likes Received:
    4,542
    Best Answers:
    123
    Trophy Points:
    665
    #5
    And you can create a script to delete the old copies
     
    sarahk, Jun 11, 2013 IP
  6. RoseHosting

    RoseHosting Well-Known Member

    Messages:
    230
    Likes Received:
    11
    Best Answers:
    11
    Trophy Points:
    138
    #6
    AutoMySQLBackup is a shell script that will create Daily, Weekly and Monthly backups of one or more of your MySQL database.
     
    RoseHosting, Jun 12, 2013 IP