Hello MySQL-users list, We are having an issue with replication and binlog files and I was hoping that this list could shed a little light on the issue for us. We have a pair of 5.1.41-community MySQL servers. We attempted to restore from the slave server, and in the process I zeroed out the mysql-bin.index file with the echo command (I know this makes me a terrible person; in my own defense, this was effective technique for restoration on on 5.0 MySQL machines).
Now, when we run: mysql> show master status; We see +------------------+-----------+--------------+------------------+ | Fil| Position | Binlog_Do_DB | Binlog_Ignore_DB | +------------------+-----------+--------------+------------------+ | mysql-bin.000121 | 429017611 | | | +------------------+-----------+--------------+------------------+ But if we run mysql> SHOW BINARY LOGS; We see Empty set (0.00 sec) And the RESET MASTER command has no effect. We saw on http://dev.mysql.com/doc/refman/5.0/en/purge-binary-logs.html Prior to MySQL 5.0.60, PURGE BINARY LOGS TO and PURGE BINARY LOGS BEFORE did not behave in the same way (and neither one behaved correctly) when binary log files listed in the .index file had been removed from the system by some other means (such as using rm on Linux). Beginning with MySQL 5.0.60, both variants of the statement fail with an error in such cases. (Bug#18199 <http://bugs.mysql.com/bug.php?id=18199> , Bug#18453 <http://bugs.mysql.com/bug.php?id=18453> ) To handle such errors, edit the .index file (which is a simple text file) manually to ensure that it lists only the binary log files that are actually present, then run again the PURGE BINARY LOGS <purge-binary-logs.html> statement that failed. However running PURGE BINARY LOGS against a file listed in the mysql-bin.index file (once this file has been updated to reflefc all of the logs contained within it's directory) still results in ERROR 1373: Target log not found in binlog index Can anyone shed some light on this issue for us? Thanks!
