MySQL Forums
Forum List  »  Replication

Re: How to quiece an mysql before taking snapshot?
Posted by: Richard
Date: November 28, 2007 09:11AM

flush tables with read lock;
flush logs;
unlock tables;

All above are the exact SQL statements you will use. It locks all the tables on the server, flushes the logs, at this poit you should now take your snapshot, then the last statement unlocks all your tables.

Here is the first hit I found on Google for using LVM. It is not exactly what you want but it will get you started.

http://blog.dbadojo.com/2007/09/mysql-backups-using-lvm-snapshots.html

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to quiece an mysql before taking snapshot?
3649
November 28, 2007 09:11AM


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.