一、开启binlog。
首先查看binlog是否开启
mysql> show variables like "log_bin"; +---------------+-------+ |Variable_name | Value +---------------+-------+ | log_bin OFF +---------------+-------+ 1 row in set ( sec)
值为OFF,需开启,开启binlog方式如下:
#vim /etc/
在[mysqld]中加入
log-bin = mysql-bin log-bin = /usr/local/mysql/log/mysql-
重启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;
写入数据
程序2-1
#coding:utf8
#
import MyS