Hi Krishna Just do the flush logs and check the last binlogs with the mysqlbinlog xxx-bin > textfile.
Thanks & Regards, Dilipkumar -----Original Message----- From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2008 11:11 AM To: mysql Subject: mysqlbinlog 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
