safe binary backup
Posted by:
Tri Bao Ho
Date: October 04, 2011 10:08AM
We have innodb-only DB (well, except schema of mysql itself). And we are doing a binary backup (e.g copying entire mysql data folder to another disk/machine). Apart from stopping mysql before doing so, is it also safe if we execute a "FLUSH TABLES WITH READ LOCK" before copying files and issue an "LOCK TABLES" after finishing copying.
Thanks,
Bao.
Edited 1 time(s). Last edit at 10/04/2011 08:12AM by Tri Bao Ho.
Subject
Views
Written By
Posted
safe binary backup
2514
October 04, 2011 10:08AM
1081
October 14, 2011 11:08AM
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.