怎么开启?
MySQL\my.ini
中,在mysqld结构中加入:log_bin=mysqlxdw
提示:mysqlxdw是文件名,可自己任意定义。
[mysqld]
port=3306
basedir=”E:/phpStudy/MySQL/”
datadir=”E:/phpStudy/MySQL/data/”
character-set-server=utf8
default-storage-engine=MyISAM
log_bin=mysqlxdw
是否启用了日志
mysql>show variables like 'log_bin';
怎样知道当前的日志
mysql> show master status;
mysql> show binlog events;
SHOW BINLOG EVENTS IN ‘mysqlxdw.000002’;
项目调试,二进制查看
show binlog events;#显示二进制日志
PURGE MASTER LOGS TO 'mysqlxdw.000001'; #清除主日志
flush logs;#刷新日志
reset master;#复位主日志
show binlog events;
PURGE MASTER LOGS TO 'mysqlxdw.000001';
flush logs;
reset master;
关注公众号,了解更多it技术(it问答网)