Re: Backup Causes Server To Crash
1. If you want a consistent dump, you need to avoid any writes during the dump. Your dumping technique probably forced that on you, hence the "locked" queries.
2. If you KILL mysql, you could have data corruption, especially MyISAM indexes -- recommend you do CHECK TABLE after coming back up.
3. To avoid stopping writes during a backup, set up replication, then backup the slave.
Subject
Views
Written By
Posted
3520
June 28, 2010 10:48AM
Re: Backup Causes Server To Crash
1543
July 06, 2010 09:41PM
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.