mysql入库保持1062_Mysql Slave库同步Master库失败提示Last_SQL_Errno: 1062

mysql> select * from media_class_jieliang where seqid='95';

+-------+----------+-------------+---------+---------+

| seqid | dateline | media_class | a_times | m_times |

+-------+----------+-------------+---------+---------+

|    95 | 20150612 | ??θ?    |      12 |      12 |

+-------+----------+-------------+---------+---------+

mysql> set names utf8;

mysql> select * from media_class_jieliang where seqid='95';

+-------+----------+-------------+---------+---------+

| seqid | dateline | media_class | a_times | m_times |

+-------+----------+-------------+---------+---------+

|    95 | 20150612 | 视频网站    |      12 |      12 |

+-------+----------+-------------+---------+---------+

2、从库查看media_class_jieliang表中id为95的值

mysql> select * from media_class_jieliang where seqid='95';

+-------+----------+-------------+---------+---------+

| seqid | dateline | media_class | a_times | m_times |

+-------+----------+-------------+---------+---------+

|    95 | 20150611 | ??θ?    |      49 |      49 |

+-------+----------+-------------+---------+---------+

mysql> set names utf8;

mysql> select * from media_class_jieliang where seqid='95';

+-------+----------+-------------+---------+---------+

| seqid | dateline | media_class | a_times | m_times |

+-------+----------+-------------+---------+---------+

|    95 | 20150611 | 视频网站    |      49 |      49 |

+-------+----------+-------------+---------+---------+

3、从库与主库中的数据不一致，手工将从库数据更新

mysql> desc media_class_jieliang;

+-------------+-------------+------+-----+---------+----------------+

| Field       | Type        | Null | Key | Default | Extra          |

+-------------+-------------+------+-----+---------+----------------+

| seqid       | int(16)     | NO   | PRI | NULL    | auto_increment |

| dateline    | varchar(10) | NO   |     | NULL    |                |

| media_class | varchar(50) | NO   |     | NULL    |                |

| a_times     | int(16)     | NO   |     | 0       |                |

| m_times     | int(16)     | NO   |     | 0       |                |

+-------------+-------------+------+-----+---------+----------------+

mysql> replace intomedia_class_jieliang(seqid,dateline,media_class,a_times,m_times) values(95,'20150612','视频网站',12,12);

4、检查更新结果

mysql> select * from media_class_jieliang where seqid='95';

+-------+----------+-------------+---------+---------+

| seqid | dateline | media_class | a_times | m_times |

+-------+----------+-------------+---------+---------+

|    95 | 20150612 | 视频网站    |      12 |      12 |

+-------+----------+-------------+---------+---------+5、停止从库服务，跳过该错误，启动从库服务

mysql> slave stop;

mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER =1;

mysql> slave start;

6、检查从库同步状态

mysql> show slave status \G;

*************************** 1. row ***************************

Slave_IO_State: Waiting for master to send event

Master_Host: 172.16.30.66

Master_User: slave

Master_Port: 3306

Connect_Retry: 60

Master_Log_File: mysql-bin.000003

Read_Master_Log_Pos: 302242453

Relay_Log_File: localhost-relay-bin.000003

Relay_Log_Pos: 1871144

Relay_Master_Log_File: mysql-bin.000003

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

Replicate_Do_DB:

Replicate_Ignore_DB:

Replicate_Do_Table:

Replicate_Ignore_Table:

Replicate_Wild_Do_Table:

Replicate_Wild_Ignore_Table:

Last_Errno: 0

Last_Error:

Skip_Counter: 0

Exec_Master_Log_Pos: 302242453

Relay_Log_Space: 42511366

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: 0

Master_SSL_Verify_Server_Cert: No

Last_IO_Errno: 0

Last_IO_Error:

Last_SQL_Errno: 0

Last_SQL_Error:

Replicate_Ignore_Server_Ids:

Master_Server_Id: 1

1 row in set (0.00 sec)

ERROR:

No query specified

数据库技术>请勿转载。如须转载请详细标明转载出处，否则追究法律责任!>