MySQL Forums
Forum List  »  Backup

Re: Any Special Requirements For Backing Up My Database?
Posted by: Benjamin Gonay
Date: March 10, 2005 05:36AM

Hi,

If you're using innodb, yes the db must be off during backup for consistency. If you're using Myisam table type, no but be sure to flush tables before and there's no updates/insert/replace queries during backup... or use FLUSH TABLES WITH READ LOCK command.

Hope this help you.
Benjamin

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Any Special Requirements For Backing Up My Database?
3026
March 10, 2005 05:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.