问题如下:
mysql>showslavestatus\G
***************************1.row***************************
Slave_IO_State:
Master_Host:172.168.3.190
Master_User:slave
Master_Port:12148
Connect_Retry:60
Master_Log_File:binlog.000001
Read_Master_Log_Pos:753
Relay_Log_File:WIN-OQBO622D6Q5-relay-bin.000002
Relay_Log_Pos:248
Relay_Master_Log_File:binlog.000001
Slave_IO_Running:No
Slave_SQL_Running:No
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno:1050
Last_Error:Error‘Table‘t‘alreadyexists‘onquery.Defaul
tdatabase:‘test‘.Query:‘createtablet(t1intprimarykey)‘
Skip_Counter:0
Exec_Master_Log_Pos:106
Relay_Log_Space:1367
Until_Condition:None
Until_Log_File:
Until_Log_Pos:0
Master_SSL_Allowed:No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master:NULL
Master_SSL_Verify_Server_Cert:No
Last_IO_Errno:0
Last_IO_Error:
Last_SQL_Errno:1050
Last_SQL_Error:Error‘Table‘t‘alreadyexists‘onquery.Defaul
tdatabase:‘test‘.Query:‘createtablet(t1intprimarykey)‘
1rowinset(0.00sec)
解决办法1如下:
1.删除t这个表
use test;
drop table t;
2.重新开启主从
start slave;
3.查看主从同步
show slave status \G
解决办法2如下:
1、停止同步
2、在mysql客户端输入下列语句
set global sql_slave_skip_counter=1
3、重新启动同步