MySQL Forums
Forum List  »  Data Recovery

Restore bin files - Small Questions
Posted by: khaled Jamel
Date: October 31, 2013 11:50AM

Hi all
i am trying to make a point-in-time recovery using bin logs.
Yesterday, after making a full backup of the Db (Innodb) from the first server [Mysql Distrib 5.1.67, for redhat-linux-gnu (x86_64)] and restore it in the second one [Mysql Distrib 5.0.95, for redhat-linux-gnu (x86_64)]; i tried today to make sync between two DBs by recovering data from binlogs stored on the first server. After copying binlog file to the second server i tried to execute the following commands :

mysqlbinlog --start-datetime="2013-10-30 00:00:01" mysql-bin.000007 | mysql -u user -ppassword
ERROR: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 83, event_type: 19
Could not read entry at offset 7217728:Error in log format or read error



mysqlbinlog --start-datetime="2013-10-30 00:00:01" mysql-bin.000007 > exportbin30-10.sql
ERROR: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 83, event_type: 19
Could not read entry at offset 7217728:Error in log format or read error


Any one have an idea which kind of problem i am facing, it is a mysql version compatibility or other thing?

Thanks



Edited 1 time(s). Last edit at 10/31/2013 11:52AM by khaled Jamel.

Options: ReplyQuote


Subject
Views
Written By
Posted
Restore bin files - Small Questions
2635
October 31, 2013 11:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.