log-error=/var/log/mysql.log log-bin=/data/binlog/mysql-bin sync_binlog=1 binlog_format=row
[root@db01 ~]# mysql -uroot -p123
mysql> create database xiaohai; mysql> drop database xiaohai;
[root@db01 binlog]# mysqlbinlog mysql-bin.000008 # at 1200 #200409 16:41:36 server id 10 end_log_pos 1297 crc32 0x84e92ac7 query thread_id=8 exec_time=0 error_code=0 set timestamp=1586421696/*!*/; create database xiaohai /*!*/; # at 1297 #200409 16:42:24 server id 10 end_log_pos 1384 crc32 0xfdf1d747 query thread_id=8 exec_time=0 error_code=0 set timestamp=1586421744/*!*/; drop database xiaohai /*!*/; delimiter ; # end of log file rollback /* added by mysqlbinlog */; /*!50003 set completion_type=@old_completion_type*/; /*!50530 set @@session.pseudo_slave_mode=0*/;
[root@db01 binlog]# mysqlbinlog mysql-bin.000008 --start-position=1200 --stop-position=1297>test.sql mysql> source /data/binlog/test.sql; mysql> show databases;
转自:https://www.cnblogs.com/yanyanqaq/p/12675968.html
如对本文有疑问, 点击进行留言回复!!
linux下文本编辑器vim的使用方法(复制、粘贴、替换、行号、撤销、多文件操作)
网友评论