13.检验复制
(1).在master上
mysql> use test;
Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| pet |
+----------------+
1 row in set (0.00 sec)
mysql> create table t1(id int,name char(10));
Query OK, 0 rows affected (0.02 sec)
mysql> insert into t1 values(1,'yxyup');
Query OK, 1 row affected (0.00 sec)
(2)在slave上查看
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| pet |
| t1 |
+----------------+
2 rows in set (0.00 sec)
mysql> select * from t1;
+------+-------+
| id | name |
+------+-------+
| 1 | yxyup |
+------+-------+
1 row in set (0.00 sec)
复制指定的数据库
1.在master上操作
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
+--------------------+
3 rows in set (0.00 sec)
mysql> use test;
Database changed
mysql> create table t1(id int,name char(10));
Query OK, 0 rows affected (0.02 sec)
mysql> create table t2(id int,name char(8));
Query OK, 0 rows affected (0.07 sec)
在slave上查看
mysql> use test;
Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| pet |
| t1 |
| t2 |
+----------------+
3 rows in set (0.00 sec)