Home  >  Article  >  Database  >  MySQL 1594错误解决方法_MySQL

MySQL 1594错误解决方法_MySQL

WBOY
WBOYOriginal
2016-06-01 13:36:001266browse

bitsCN.com

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;

 

bitsCN.com
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn