MySQL Forums
Forum List  »  Data Recovery

Recovery from binlog
Posted by: Adam Warnowski
Date: August 05, 2018 06:50AM

I have problem with recovery from binlog. I have done:
mysqlbinlog -v --base64-output=DECODE-ROWS log_file
Inside generated I see something like:
### UPDATE test.t
### WHERE
### @1=1
### @2='apple'
### @3=NULL
### SET
### @1=1
### @2='pear'
### @3='2009:01:01'
So it is impossible to import this file. Please help if I should use some utils which converts me this to sql:
UPDATE test.t SET col1=1, col2='pear', col3=2009:01:01' WHERE col1 = 1;

or maybe there is switch to use with mysqlbinlog which generates normal sql's.
In some lines of output I see normal UPDATEs. I don't know what it depends on.

Options: ReplyQuote


Subject
Views
Written By
Posted
Recovery from binlog
337
August 05, 2018 06:50AM
171
August 05, 2018 12:49PM
188
August 05, 2018 11:04PM


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.