确认binlog是否已经启用:
show variables like '%log_bin%';
展示所有的binlog文件
show master logs;
展示最新的binlog文件
show master status;
清空binlog文件
reset master;
Mysql复制主要有三种方式:
基于SQL语句的复制(statement-based replication, SBR)
基于行的复制(row-based replication, RBR)
混合模式复制(mixed-based replication, MBR)
确认binlog的模式:
show global variables like "%binlog_format%";
恢复数据
/usr/bin/mysqlbinlog --no-defaults /var/lib/mysql/binlog.000040 | mysql -uroot -p yjs_test