1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Auto backup Mysql database

Discussion in 'MySQL' started by ozkorallah, Jan 6, 2009.

0
  1. #1
    hello,

    i'm looking for auto backup Mysql databases script or software?

    any help
     
    ozkorallah, Jan 6, 2009 IP
  2. caribbean_hatch

    caribbean_hatch Peon

    Messages:
    19
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    There's several ways to do it. 1) If you now for sure your server isn't actually doing anything you can just make copies of the binary data files 2)You can lock & flush the tables then SELECT INTO ... OUTFILE or 3) use the mysqldump utility, or 4) Use the mysqlhotcopy Perl script.

    To make it automatic, set it up as a cron job (if you're on Unix)
     
    caribbean_hatch, Jan 6, 2009 IP
  3. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #3
    Simply create a script which will use mysqldump to take backup. And run this script on regular intervals to take backup. Also look at this tutorial.
     
    mwasif, Jan 6, 2009 IP
  4. robuk21

    robuk21 Peon

    Messages:
    24
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    If your on a linux server then take a look at this link.

    I use this script to back up my MySQL databases, you basically just fill in the variables and then set the script up to run as a cron job at regular intervals. It's very easy to implement, though it helps if you know your way around a linux server.
     
    robuk21, Feb 19, 2009 IP