MySQL1594错误解决方法_MySQL

MySQL 1594错误解决方法

MySQL 1594错误解决方法：

例： www.bitsCN.com

Master_Log_File: mysqld-bin.000042

Read_Master_Log_Pos: 99749808

Relay_Log_File: mysqld-relay-bin.000083

Relay_Log_Pos: 15995

Relay_Master_Log_File: mysqld-bin.000041

Slave_IO_Running: Yes

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

我们只需要做一遍change master 就好了

这里我们的master_log_file和master_log_pos这两个值都不要改变

mysql > slave stop; change master to Master_Log_File="mysqld-bin.000042", aster_Log_Pos=99749808;slave start;