mysql忽略复制的表

[mysqld]
binlog-ignore-db = mysql
replicate-ignore-db = mysql
binlog-ignore-db = information_schema
replicate-ignore-db = information_schema
binlog-ignore-db = performance_schema
replicate-ignore-db = performance_schema
binlog-ignore-db = test
replicate-ignore-db = test
replicate-wild-ignore-table=mysql.%
replicate-wild-ignore-table=information_schema.%
replicate-开发云主机域名wild-ignore-table=performance_schema.%
replicate-wild-ignore-table=test.%

相关推荐: 数据库MySQL简单操作(二）

一、数据的增删改查1.1 插入记录1.1.1插入单条数据INSERT INTO 表名 （字段名1，字段名2，……，字段名N）VALUES (字段1值，字段2值，……，字段N值);①这是把所有的字段都带上INSERT INTO student (id,`name…