mysql slave 重新同步单个表的过程

[导读]mysql> RENAME TABLE rep TO rep_maint;Query OK, 0 rows affected (0.01 sec) mysql> SELECT * FROM rep_maint INTO OUTFILE '/tmp/rep.txt';Query OK, 0 rows affected (0.01 sec) mysql> CREATE TABLE r... mysql> RENAME TABLE rep TO rep_maint;
Query OK, 0 rows affected (0.01 sec)
 
mysql> SELECT * FROM rep_maint INTO OUTFILE '/tmp/rep.txt';
Query OK, 0 rows affected (0.01 sec)
 
mysql> CREATE TABLE rep_new LIKE rep_maint;
Query OK, 0 rows affected (0.00 sec)
 
mysql> LOAD DATA INFILE '/tmp/rep.txt' INTO TABLE rep_new;
Query OK, 0 rows affected (0.01 sec)
Records: 0  Deleted: 0  Skipped: 0  Warnings: 0
 
mysql> RENAME TABLE rep_maint TO rep_old, rep_new TO rep;
Query OK, 0 rows affected (0.00 sec)