From: Krishna Chandra Prajapati (prajapatikcgmail.com)
Date: Wed Jun 04 2008 - 00:41:00 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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.

[rootedventures76 ~]$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 COMPLETION_TYPE=OLD_COMPLETION_TYPE*/;

Thanks
--
Krishna Chandra Prajapati
MySQL DBA,
Email-id: prajapatikcgmail.com

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]