mysqldump vs MySQLHotcopy vs MySQLDumper

Discussion in 'vBulletin Discussions' started by Abomination, Jun 14, 2009.

  1. Abomination

    Abomination Zealot

    Joined:
    Jun 1, 2009
    Messages:
    1,514
    Likes Received:
    102
    This has been posted more than once on vb.com

    From the link about MySQLHotCopy:
    My goal is to have a cron job that makes a backup of the database, and another cron job that sends it to another hosting account (or somewhere on the web). It appears MySQLDumper will do that, but of course that is another piece of software to keep up to date and occasionally test.

    Right now I'm using mysqldump in a cron job to only make a database backup and am not sending it elsewhere.


    What are the advantages & disadvantages of the 3 methods for a 300MB database? Any input from those who have used & tested at least 2 of these methods? :confused:
     

Share This Page