一、开启binlog。
首先查看binlog是否开启
mysql> show variables like "log_bin";
+---------------+-------+
|Variable_name | Value
+---------------+-------+
| log_bin OFF
+---------------+-------+
1 row in set (0.00 sec)
值为OFF,需开启,开启binlog方式如下:
#vim /etc/my.cnf
在[mysqld]中加入
log-bin = mysql-bin
log-bin = /usr/local/mysql/log/mysql-bin.log
重启mysql服务
#service mysqld stop
#service mysqld start
二、模拟数据写入
建库
create database backup;
建表
CREATE TABLE `number` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
`updatetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8