From: Marcus Bointon
Date: September 22 2009 10:21pm
Subject: Re: borked replication
List-Archive: http://lists.mysql.com/replication/1698
Message-Id: <8A15A022-96E3-4D2B-877B-A61B4E8A24BE@synchromedia.co.uk>
MIME-Version: 1.0 (Apple Message framework v1076)
Content-Type: text/plain; charset=us-ascii; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit

On 22 Sep 2009, at 17:39, Andrei F wrote:

> 1) grab a dump of the master (server) database: mysqldump -u -p  
> dbname >
> dbname.sql

This will usually work, but won't always as it doesn't guarantee that  
the data is in a consistent state. This becomes more of a problem as  
your database gets bigger and the dumps take longer (and thus  
opportunities for inconsistency increase). Take a look at Xtrabackup  
which doesn't suffer this problem and is very good for setting up new  
slaves (or rebuilding broken ones), I wrote an article about it:
http://marcus.bointon.com/archives/87-MySQL-backups-with-Perconas-XtraBackup.html

Marcus
-- 
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK resellers of info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/