Question about a Mysql backup script

Discussion in 'Linux VPS/Dedicated - cPanel' started by Nalco, Jan 13, 2008.

  1. Nalco

    Nalco New Member

    I am looking for a way to backup a couple databases on a daily basis automatically. I came across this script which looks decent:

    And I was wondering if anyone had any experience with it. If not, anyone know of another such script that you like to use for such purposes??

  2. rezag

    rezag New Member

    Thats something I am looking for too, interested to see what others recommend, what I am looking at currently that looks like a good solution is mysqlhotcopy
  3. ppc

    ppc Moderator

    I have seen people use this, successfully.
  4. Nalco

    Nalco New Member

    Thanks for the replies!

    I am going to try that script ppc. At first I was leary, as I thought I would have to install pear, luckily pear is already installed on my server.

  5. rezag

    rezag New Member

    I would rather not use mysqldump, in my experience it sometimes needs too much resources when doing it but even if that doesn't or shouldn't happen creating one huge file to backup/download everytime is something I prefer not to do.
  6. khiltd

    khiltd New Member

    So you want an incremental database backup? That would be a lot more effort than it's worth.
  7. Dan

    Dan Moderator

    I've been using PHPMyBackupPro for a number of months now and have been quite happy with it.
  8. rezag

    rezag New Member

    True, thats why I am looking at mysqlhotcopy with rsync, but first I have to make sure it works and then set up the proper rsync command/cron

    I believe these reasons make it worthwhile:

  9. khiltd

    khiltd New Member

    So instead of a huge dump file you'll have an even huger zipped directory. I see the advantages of the methodology, but you're not going to avoid a large download.
  10. rezag

    rezag New Member

    But how about setting up rsync to an offsite location so only changed tables (files) are transferred/downloaded? Shouldn't that at least cut down on size a bit or maybe even more if some individual tables are not changed?
    That is my understanding, obviously am not much of an unix expert, any thoughts?
  11. khiltd

    khiltd New Member

    I'm assuming you'd be relying on file modification dates to tell you what's changed and what hasn't, and they're unfortunately not the most reliable things in the world. It'd probably work for the most part, but if it's truly important data I'd rather have it all copied every time myself.

Share This Page