查看binlog文件

• 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'