工作日志之-MySQL slave Replication Error

Rep error: Error 1201 (HY000)

工作日志之-MySQL slave Replication Error Description： mysql> start slave; ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log [root@slave ~]# tail /var/log/mysqld.log 090105 11:53:52 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000013' (relay_log_pos 235) 090105 11:53:52 [ERROR] Could not find target log during relay log initialization ... [root@slave mysql]# ls /var/run/mysqld/ mysqld-relay-bin.000001  mysqld-relay-bin.000003  mysqld-relay-bin.000005  mysqld-relay-bin.index   mysqld-relay-bin.000002  mysqld-relay-bin.000004  mysqld-relay-bin.000006 [root@slave mysql]# cat master.info 14 mysql-bin.000010 1235 192.168.3.21 slave 29019853 3307 60 0 [root@slave mysql]# cat relay-log.info /var/run/mysqld/mysqld-relay-bin.000013 235 mysql-bin.000010 1235 3 50703 Resolve solution: [root@slave ~]# service mysqld stop [root@slave mysql]# rm -fr master.info [root@slave mysql]# rm -fr relay-log.info [root@slave ~]# grep skip-slave-start /etc/my.cnf skip-slave-start [root@slave ~]# service mysqld start [root@master ~]# mysql -uroot -p mysql> show master status; +------------------+----------+--------------+------------------+ | File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | +------------------+----------+--------------+------------------+ | mysql-bin.000011 |       98 |              |                  | +------------------+----------+--------------+------------------+ [root@slave ~]# mysql -uroot -p mysql> change master to master_log_file='mysql-bin.000011', master_log_pos=98, master_host='192.168.3.21', master_port=3307, master_user='slave', master_password='12345678'; Query OK, 0 rows affected (0.02 sec) mysql> start slave; Query OK, 0 rows affected (0.00 sec) mysql> show slave status\G *************************** 1. row ***************************              Slave_IO_State: Waiting for master to send event                 Master_Host: 192.168.3.21                 Master_User: slave                 Master_Port: 3307               Connect_Retry: 60             Master_Log_File: mysql-bin.000011         Read_Master_Log_Pos: 98              Relay_Log_File: mysqld-relay-bin.000002               Relay_Log_Pos: 235       Relay_Master_Log_File: mysql-bin.000011            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: 98             Relay_Log_Space: 235             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 1 row in set (0.00 sec)