On 12/4/09 11:59 AM, "Robinson, Eric" <eric.robin...@psmnv.com> wrote:
>> (2) why delete slave logs when you can >> restart the slave with --skip-slave and >> then use CHANGE MASTER TO? > > Well... I guess mainly because I didn't know about that option! I > thought I needed to "fake out" mysql on this, but it sounds like I can > just do 'flush tables with read lock;reset master;' on the master and > 'change master to...;' on the slave. So cool. Thanks for the input! 16.1.1 is probably my favorite chapter of the manual. 16.1.1.8 is particularly worth a read. http://dev.mysql.com/doc/refman/5.0/en/replication-howto-existingdata.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
