After MySQL replication is configured, an error is reported when starting slave as follows:
mysql> start slave;
ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log
mysql>
Looking for it on the Internet, it turns out that there are two files to delete. It is estimated that it was generated yesterday when other people failed in the test.
/var/lib/mysql/ master.info
/var/lib/mysql/relay- log.info
Just delete it.
mysql> start slave;
Query OK, 0 rows affected (0.01 sec)
mysql>
Refer to the following documents:
http://blog.sina.com.cn/s/blog_ 51d3553f0100j5m2.html
Read More:
- MySQL master-slave replication. An error is reported when starting slave. Slave failed to initialize relay log info structure from the repository
- After the two hosts set up the master-slave replication of MySQL, the show slave status displays: last_ IO_ Error: error connecting to master ……
- MySQL operation and maintenance slave_ skip_ errors
- The problem of master-slave database synchronization stop caused by MySQL deleting data
- MySQL uses net start MySQL startup prompt (failed to start, the service did not report any error)
- Solve net start mysql, start MySQL service, prompt system error 5. Access denied.
- Solve MySQL error 2002 (HY000)
- ERROR 2005 (HY000): Unknown MySQL server host
- [MySQL] error 1396 (HY000): Operation create user failed for ‘MySQL’ @’localhost ‘
- Solution to error 2002 (HY000) in MySQL
- ERROR 2002 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)
- About error 1005 (HY000) in MySQL: can’t create table ‘_______ ‘(errno: 150) fool’s plan
- Solution to error 2002 (HY000) in MySQL login startup
- Error 2003 (HY000): can’t connect to MySQL server on ‘localhost’ (10061)
- Error 2005 (HY000) unkonw MySQL server host…
- MySQL error set: failed to start mysql.service : Unit mysql.service is masked.
- SQL exception handling – MySQL error 1005 (HY000): can’t create table ‘TMP’ (errno: 13)
- MySQL error: error 1010 (HY000) when deleting database
- MySQL error 1205 (HY000): lock wait timeout exceeded; try restarting transaction
- mysql load data infile ERROR 13 (HY000): Can’t get stat of