Hi All, When I am trying to open the current binlog file. Its giving that binlog was not closed properly. (Please see the bold line) Does it mean that active binlog can only be opened by stopping mysql server. Is there any other way to open the current binlog file.
[EMAIL PROTECTED] ~]$mysqlbinlog /var/log/mysql/mysql-bin.000014 /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 4 #080604 9:18:00 server id 1 end_log_pos 98 Start: binlog v 4, server v 5.0.45-log created 080604 9:18:00 at startup *# Warning: this binlog was not closed properly. Most probably mysqld crashed writing it.* ROLLBACK/*!*/; DELIMITER ; # End of log file ROLLBACK /* added by mysqlbinlog */; /*!50003 SET [EMAIL PROTECTED]/; Thanks -- Krishna Chandra Prajapati MySQL DBA, Email-id: [EMAIL PROTECTED]