Anonymous wrote on Mon, 01 March 2004 13:26All, I have a database where the tables are InnoDB. I am working on the backup procedure, and would like to implement a process where the database is backed up without having to shut it down (live, or hot backup). Reading the documentation, it appears the only option I have is to purchase a solution from InnoDB ($500/yr). Is there a free option out there to do this?
Thank you, Kevin Williams Well, $500 is not bad for a hot backup solution. That being said you can use mysqldump with the --single-transaction option to achieve the same effect, but it will be slower and (probably) take up more storage space. You should also make sure you are using a recent version of mysql or make sure to disable foreign key checks before doing your restore as mysqldump does not back-up the tables with concern for the integrity constraints. -- Regards, Mike Hillyer Webmaster/Moderator http://www.vbmysql.com Read my blog at: http://www.vbmysql.com/mike/blog -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
