Binary log problems
am 11.01.2010 16:26:57 von sql06I tried to look at the binary logs by using phpMyAdmin, but got an error:
SQL error:
SHOW BINLOG EVENTS LIMIT 0, 30;
MySQL said:
#1220 - Error when executing command SHOW BINLOG EVENTS: Wrong offset or I/=
O=20
error.
=46rom the error-file:
100111 16:15:40 [ERROR] Error in Log_event::read_log_event(): 'Found invali=
d=20
event in binary log', data_len: 100, event_type: 2
100111 16:16:51 [ERROR] Error in Log_event::read_log_event(): 'Found invali=
d=20
event in binary log', data_len: 100, event_type: 2
100111 16:17:08 [ERROR] Error in Log_event::read_log_event(): 'Found invali=
d=20
event in binary log', data_len: 100, event_type: 2
What is causing this? How can I fix this?
I'm using version mySQL 5.1.42.
=2D-=20
J=F8rn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg