Replication fun

[Tyler Hall]

Hi, I have two quick questions..

1) The documentation says to do 'lock tables with read lock' and then do a mysqldump, so nothing gets written as you do the dump, however if you do mysqldump dbname > db.sql while read lock is on, it just hangs with a 0 byte. What is the correct way to get a dump of the DB without it changing?

2) I constantly get these error messages if the machine shuts down incorrectly:

090811 5:16:43 [Note] Slave SQL thread initialized, starting replication in log 'bin.000013' at position 634998665,
relay log '/var/log/mysql-master/relay.000001' position: 4
090811 5:16:44 [Note] Slave I/O thread: connected to master 'repi@blahblah:3306', replication started in log 'bin.000013' at position 634998665
090811 5:16:44 [ERROR] Error reading packet from server: Could not find first log file name in binary log index file ( server_errno=1236)
090811 5:16:44 [ERROR] Got fatal error 1236: 'Could not find first log file name in binary log index file' from master when reading data from binary log
090811 5:16:44 [Note] Slave I/O thread exiting, read up to log 'bin.000013', position 634998665


I can't find a way to fix them unless I wipe out the db and start the replication from scratch. (I get these errors on the slaves)