Program Name:binlogback
Summary:Analyze mysql binlog(only for row format) in reverse order ,to restore incorrect operation
#usage:
./binlogback.py -f mysql-bin.000001 -m dsec -B unit -t t1 -c c1,c2,c3
-f,--file binlog path,multi file split by ',',do not support regex of path
-m,--mode asc or desc,default is desc,recovering data need set mode=desc
-B,--database schema name
-t,--table table name
-c,--columns all columns:c1,c2,c3...
-b,--begin-datetime begin time,yyyy-MM-DD HH:mm:ss
-s,--end-datetime end time,yyyy-MM-DD HH:mm:ss
-h,--help usage
-v,--version print version
#Limits:
1:the table must have a primary key,and no ddl changes of any columns,if column numbers changed between begin-datetime and end-datetime,program will exit(1)
2:only mysql 5.5 is supported so far
3:only check row format
4:type of time will be unpacked with error value when value is less than "00:00:00"
#Concact me:
Email:zhkeke2008@163.com
email me when you meet any error or any bug.