-v, --verbose???????Reconstruct pseudo-SQL statements out of row events. -v

??????????????????????-v adds comments on column data types.

-v參數(shù)是可能從binlog中重建sql語句，這對于誤操作的恢復(fù)很我?guī)椭?vv增加了備注部分

[root@qht131 mysql]# mysqlbinlog --no-defaults mysql_bin.000039 > nov.sql
[root@qht131 mysql]# mysqlbinlog --no-defaults -v mysql_bin.000039 > onev.sql
[root@qht131 mysql]# mysqlbinlog --no-defaults -v -v mysql_bin.000039 > twov.sql

加了-v參數(shù)比不加-v的多了sql部分：

[root@qht131 mysql]# diff nov.sql onev.sql 50a51,53 > ### INSERT INTO `db1`.`t1` > ### SET > ### ? @1=1 71a75,77 > ### INSERT INTO `db1`.`t1` > ### SET > ### ? @1=2 92a99,101 > ### INSERT INTO `db1`.`t1` > ### SET > ### ? @1=3 113a123,125 > ### INSERT INTO `db1`.`t1` > ### SET > ### ? @1=4

-v和-vv的區(qū)別在于-vv增加了備注部分

[root@qht131 mysql]# diff onev.sql twov.sql 53c53 < ### ? @1=1 --- > ### ? @1=1 /* INT meta=0 nullable=1 is_null=0 */ 77c77 < ### ? @1=2 --- > ### ? @1=2 /* INT meta=0 nullable=1 is_null=0 */ 101c101 < ### ? @1=3 --- > ### ? @1=3 /* INT meta=0 nullable=1 is_null=0 */ 125c125 < ### ? @1=4 --- > ### ? @1=4 /* INT meta=0 nullable=1 is_null=0 */

--base64-output參數(shù)用來控制binlog部分是否顯示出來的，指定為decode-rows表示不顯示binglog部分

[root@qht131 mysql]# mysqlbinlog --no-defaults -v mysql_bin.000039 > nobase64.sql
[root@qht131 mysql]# mysqlbinlog --no-defaults -v --base64-output=decode-rows mysql_bin.000039 > base64.sql

[root@qht131 mysql]# diff nobase64.sql base64.sql8,12d7 < BINLOG ' < JV7gWg8QJwAAdwAAAHsAAAABAAQANS43LjIxLWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA < AAAAAAAAAAAAAAAAAAAlXuBaEzgNAAgAEgAEBAQEEgAAXwAEGggAAAAICAgCAAAACgoKKioAEjQA < AZMlD6o= < '/*!*/; 46,50d40 < < BINLOG ' < XGHgWhMQJwAALAAAAO8BAAAAAGwAAAAAAAEAA2RiMQACdDEAAQMAAeAiC0o= < XGHgWh4QJwAAKAAAABcCAAAAAGwAAAAAAAEAAgAB//4BAAAAcayaSA== < '/*!*/; 70,74d59 < < BINLOG ' < X2HgWhMQJwAALAAAAOoCAAAAAGwAAAAAAAEAA2RiMQACdDEAAQMAAZQPLZ0= < X2HgWh4QJwAAKAAAABIDAAAAAGwAAAAAAAEAAgAB//4CAAAA5lfIsg== < '/*!*/; 94,98d78 < < BINLOG ' < 4WHgWhMQJwAALAAAAOUDAAAAAGwAAAAAAAEAA2RiMQACdDEAAQMAAVfdyUk= < 4WHgWh4QJwAAKAAAAA0EAAAAAGwAAAAAAAEAAgAB//4DAAAAlL7CPg== < '/*!*/; 118,122d97 < < BINLOG ' < YWLgWhMQJwAALAAAAOAEAAAAAGwAAAAAAAEAA2RiMQACdDEAAQMAAXrMoIc= < YWLgWh4QJwAAKAAAAAgFAAAAAGwAAAAAAAEAAgAB//4EAAAAV5wOww== < '/*!*/;

---------------------?

作者：zuozhiji?
來源：CSDN?
原文：https://blog.csdn.net/jolly10/article/details/80077366?
版權(quán)聲明：本文為博主原創(chuàng)文章，轉(zhuǎn)載請附上博文鏈接！

總結(jié)

以上是生活随笔為你收集整理的mysqlbinlog -v与-vv --base64-output 与不加的区别的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。