-
show binary logs; No connection. Trying to reconnect... Connection id: 24563949 Current database: *** NONE *** +-------------------+------------+ | Log_name | File_size | +-------------------+------------+ | mysql-bini.000615 | 1073742313 | | mysql-bini.000616 | 831745546 | +-------------------+------------+
- 进入mysql命令行,输入 show master status\G; 查看当前使用的binlog文件名称
mysql> show master status\G;
*************************** 1. row ***************************
File: mysql-bini.000616
Position: 831135687
Binlog_Do_DB:
Binlog_Ignore_DB:
1 row in set (0.00 sec)
ERROR:
No query specified
- 查看当前binlog文件的解码后的输出
mysqlbinlog --base64-output=decode-rows -v --database=*** --start-datetime="2020-04-21 10:21:09" --stop-datetime="2020-04-21 10:38:50" mysql-bini.000616 > sanjiaomao.txt
#200421 10:37:06 server id 1 end_log_pos 826960637 Table_map: `database_name`.`table_name` mapped to number 559978
#200421 10:37:06 server id 1 end_log_pos 826960947 Update_rows: table id 559978 flags: STMT_END_F
### UPDATE `database_name`.`table_name`
### WHERE
### @1=10023670
### @2='NIKE 运动系列,测试下架'
### @3='NIKE20200220'
### @4=40
### @5=26
### @6=2
### @7=3
### @8=3
### @9=1582041600
### @10=000000009.000000000
### @11=000000999.000000000
### @12=1582183309
### @13=1582189807
### @14=1582189043
### @15=1582189807
### @16=2
### @17=0
### @18=''
### @19=0
### @20=0
### @21='1'
### @22=1
### @23=000000119.000000000
### @24='测试下架'
### @25=''
### @26=''
### @27=''
### @28='0,1'
### SET
### @1=10023670
### @2='NIKE 运动系列,测试下架'
### @3='NIKE20200220'
### @4=40
### @5=26
### @6=2
### @7=3
### @8=3
### @9=1582041600
### @10=000000009.000000000
### @11=000000999.000000000
### @12=1582183309
### @13=1587436626
### @14=1587436626
### @15=1587436626
### @16=1
### @17=0
### @18=''
### @19=0
### @20=0
### @21='1'
### @22=1
### @23=000000119.000000000
### @24='测试下架'
### @25=''
### @26=''
### @27=''
### @28='0,1'
# at 826960947
#200421 10:37:06 server id 1 end_log_pos 826960974 Xid = 719034393
COMMIT/*!*/;
# at 826960974
#200421 10:37:06 server id 1 end_log_pos 826961054 Query thread_id=24547579 exec_time=0 error_code=0
SET TIMESTAMP=1587436626/*!*/;
如果更新了多行则binlog语句
### UPDATE `database_name`.`table_name`
### WHERE
### @1=2
### @2=10000090
### @3='/2019/12/26/18/016b369c0e976cbc4cddfade11a06e1992.jpg'
### @4='http://flv01.static.yhbimg.com/ufo/encode/mp4/10083182649371_1577253022_183.mp4'
### @5=''
### SET
### @1=2
### @2=10000090
### @3='/2019/12/26/18/016b369c0e976cbc4cddfade11a06e1992.jpg'
### @4='http://flv01.static.yhbimg.com/ufo/encode/mp4/10083182649371_1577253022_183.mp4'
### @5='/2019/12/26/18/016b369c0e976cbc4cddfade11a06e1992.jpg'
### UPDATE `database_name`.`table_name`
### WHERE
### @1=4
### @2=10023668
### @3='/2019/12/26/18/01e34cac7d5b4eb4d89b90d34df81dd317.jpg'
### @4=''
### @5=''
### SET
### @1=4
### @2=10023668
### @3='/2019/12/26/18/01e34cac7d5b4eb4d89b90d34df81dd317.jpg'
### @4=''
### @5='/2019/12/26/18/016b369c0e976cbc4cddfade11a06e1992.jpg'
### UPDATE `database_name`.`table_name`
### WHERE
### @1=10
### @2=33
### @3='url'
### @4='update_url_last'
### @5=''
### SET
### @1=10
### @2=33
### @3='url'
### @4='update_url_last'
### @5='/2019/12/26/18/016b369c0e976cbc4cddfade11a06e1992.jpg'