恢复slave从机上的部分表
发布时间：2022-03-25 10:59:43 所属栏目：MySql教程 来源：互联网
导读：以下案例演示重新初始化slave上的个别表，如test01和test02. 1、停止slave复制 点击(此处)折叠或打开 mysql stop slave; Query OK, 0 rows affected (0.02 sec) 2、在master导出这张表，并记录下同步的binlog和POS点 mysqldump -uroot -pmysql -q --single
|
以下案例演示重新初始化slave上的个别表，如test01和test02. 1、停止slave复制 点击(此处)折叠或打开 mysql> stop slave; Query OK, 0 rows affected (0.02 sec) 2、在master导出这张表，并记录下同步的binlog和POS点 mysqldump -uroot -pmysql -q --single --master-data=2 test test01 test02 > test_01_test_02.sql 3、查看test_01_test_02.sql文件，找到记录的binlog和POS点 MASTER_LOG_FILE='mysql-bin.000003', MASTER_LOG_POS=3407; 4、把test_01_test_02.sql复制到slave上，并做change master指向 点击(此处)折叠或打开 mysql> start slave until master_log_file='mysql-bin.000003', MASTER_LOG_POS=3407; Query OK, 0 rows affected, 1 warning (0.01 sec) 直到sql_thread线程为NO，这期间的同步报错一律跳过即可，可用如下命令跳过： stop slave; set global sql_slave_skip_counter=1; start slave; 5、在slave上导入 点击(此处)折叠或打开 mysql> source /mysql/dump/test_01_test_02.sql Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.04 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.04 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 6 rows affected (0.01 sec) Records: 6 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.06 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.07 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 6 rows affected (0.01 sec) Records: 6 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) 6、导入完毕之后，开启同步即可。 点击(此处)折叠或打开 mysql> start slave; Query OK, 0 rows affected (0.01 sec) （编辑：武汉站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
