From: Marcus Bointon
Date: November 23 2007 10:21am
Subject: Re: replication on Linux broken after db restore
List-Archive: http://lists.mysql.com/replication/1011
Message-Id: <6E45C8B8-2826-4274-8D7F-1C5AA0452515@synchromedia.co.uk>
MIME-Version: 1.0 (Apple Message framework v915)
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit

On 23 Nov 2007, at 09:15, FMGreen wrote:

>> mysql> FLUSH TABLES WITH READ LOCK;


If you're using InnoDB for everything, there is an alternative that's  
much less disruptive:

mysqldump --opt --single-transaction --master-data > dump.sql

This ensures that the data dump is in a consistent state and provides  
master log file and position info, ready to import into a slave.

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/