mysql命令总结

mysqlbinlog

mysqlbinlog命令可以查看binlog日志，下面的命令可以导出mysqlbinlog的查看结果

/xxx/xxx/bin/mysqlbinlog --no-defaults --database=xxx  --base64-output=decode-rows -v  /xxx/xxx/xxx/data/mysql-bin.000016 >/tmp/binlog007.sql

导出来的文件内容如下，可以从里边看到具体mysql执行了语句

SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/;
# at 7239646
#200915 13:02:13 server id 129  end_log_pos 7239718 CRC32 0x70477fcc 	Query	thread_id=19491	exec_time=0	error_code=0
SET TIMESTAMP=1600146133/*!*/;
/*!\C utf8 *//*!*/;
SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=33/*!*/;
BEGIN
/*!*/;
# at 7239718
#200915 13:02:13 server id 129  end_log_pos 7239860 CRC32 0xa31f925a 	Table_map: `ecms`.`f_pqxx` mapped to number 111
# at 7239860
#200915 13:02:13 server id 129  end_log_pos 7240682 CRC32 0xf2faeb45 	Update_rows: table id 111 flags: STMT_END_F
### UPDATE `ecms`.`f_pqxx`
### WHERE
###   @1='02CE70B2_9C38_A8B0_9899_E3729A757195'
###   @2='AEDBF537_875D_99F5_0713_B55822B6712A'
###   @3='（2020）苏民初21199号'
###   @4='21199'
###   @5=2
###   @6=1
###   @7=1
###   @8='E38A05D0_6D9B_B40A_7258_97FC54079F36'
###   @9='第九法庭'
###   @10='-'
###   @11=1
###   @12=2
###   @13=1
###   @14=-1 (255)
###   @15=-1 (255)
###   @16='2020-09-11'
###   @17='10:28:00'
###   @18='2020-09-11'
###   @19='12:28:00'
###   @20='2020-09-11'
###   @21='10:28:00'
###   @22='2020-09-11'
###   @23='12:28:00'
###   @24='0'
###   @25=0
###   @26=1
###   @27=0
###   @28=-1 (255)
###   @29='-'
###   @30=0
###   @31=0
###   @32=0
###   @33=1150
###   @34='江苏省高级人民法院'
###   @35=2
###   @36='14EA3FE1_8A9C_EAA9_E912_914D0D3F4E84'
###   @37='庹石磊1111'
###   @38=1
###   @39='-'
###   @40=0
###   @41=0
###   @42=1600141121
###   @43=1599791403
###   @44=1
###   @45=-1 (4294967295)
### SET
###   @1='02CE70B2_9C38_A8B0_9899_E3729A757195'
###   @2='AEDBF537_875D_99F5_0713_B55822B6712A'
###   @3='（2020）苏民初21199号'
###   @4='21199'
###   @5=2
###   @6=1
###   @7=1
###   @8='E38A05D0_6D9B_B40A_7258_97FC54079F36'
###   @9='第九法庭'
###   @10='-'
###   @11=1
###   @12=2
###   @13=1
###   @14=-1 (255)
###   @15=-1 (255)
###   @16='2020-09-11'
###   @17='10:28:00'
###   @18='2020-09-11'
###   @19='12:28:00'
###   @20='2020-09-11'
###   @21='10:28:00'
###   @22='2020-09-11'
###   @23='12:28:00'
###   @24='0'
###   @25=0
###   @26=1
###   @27=0
###   @28=-1 (255)
###   @29='-'
###   @30=0
###   @31=0
###   @32=0
###   @33=1150
###   @34='江苏省高级人民法院'
###   @35=2
###   @36='14EA3FE1_8A9C_EAA9_E912_914D0D3F4E84'
###   @37='庹石磊'
###   @38=1
###   @39='-'
###   @40=0
###   @41=0
###   @42=1600146133
###   @43=1599791403
###   @44=1
###   @45=-1 (4294967295)
# at 7240682
#200915 13:02:13 server id 129  end_log_pos 7240713 CRC32 0xd01822ca 	Xid = 4612902
COMMIT/*!*/;
SET @@SESSION.GTID_NEXT= 'AUTOMATIC' /* added by mysqlbinlog */ /*!*/;
DELIMITER ;
# End of log file
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;