您的位置:首页 > 博客中心 > 数据库 >

/usr/local/mysql/bin/mysqlbinlog -vv /var/lib/bin/mysql-bin.000008 --base64-output=DECODE-ROWS --start-pos=307

时间:2022-03-13 22:55

/usr/local/mysql/bin/mysqlbinlog -vv /var/lib/bin/mysql-bin.000008 --base64-output=DEcode-ROWS  --start-pos=307

 

问题:这个究竟是什么意思

[root@ma mysql]# /usr/local/mysql/bin/mysqlbinlog -vv /var/lib/bin/mysql-bin.000008 --base64-output=DEcode-ROWS --start-pos=307
Warning: Using unique option prefix start-pos instead of start-position is deprecated and will be removed in a future release. Please use the full name instead.
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 307
#140820 7:56:56 server id 1 end_log_pos 338 CRC32 0x3ebc4dbb Xid = 42
COMMIT/*!*/;
# at 338
#140820 7:58:29 server id 1 end_log_pos 361 CRC32 0x2db75773 Stop
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
[root@ma mysql]# /usr/local/mysql/bin/mysqlbinlog -vv /var/lib/bin/mysql-bin.000008 --start-pos=307
Warning: Using unique option prefix start-pos instead of start-position is deprecated and will be removed in a future release. Please use the full name instead.
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#140820 7:56:31 server id 1 end_log_pos 120 CRC32 0x4e0c426a Start: binlog v 4, server v 5.6.15-log created 140820 7:56:31
BINLOG ‘
L+TzUw8BAAAAdAAAAHgAAAAAAAQANS42LjE1LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAXAAEGggAAAAICAgCAAAACgoKGRkAAWpC
DE4=
‘/*!*/;
# at 307
#140820 7:56:56 server id 1 end_log_pos 338 CRC32 0x3ebc4dbb Xid = 42
COMMIT/*!*/;
# at 338
#140820 7:58:29 server id 1 end_log_pos 361 CRC32 0x2db75773 Stop
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;

测试如下,貌似不加中个参数没有办法指定了start-pos的位置

/usr/local/mysql/bin/mysqlbinlog -vv /var/lib/bin/mysql-bin.000008 --base64-output=DEcode-ROWS --start-pos=307,布布扣,bubuko.com

热门排行

今日推荐

热门手游