Mysql Replication error: Slave failed to initialize relay log info structure from the repository after changing hostname
Below are the steps to fix this issue: 1. Shut down your old slave server and make a copy of the data directory to your new slave. Make sure you get the old slave’s master.info and relay-log.info files. Once you have a copy of the data directory, you can restart the old slave if desired. The rest of these steps are performed on the new slave. 2. Rename the master.info to master.info.oldslave and relay-log.info to relay-log.info.oldslave. 3. Edit /etc/my.cnf and add the line “skip-slave-start” (without the quotes) to the [mysqld] section. 4. Start the new slave. This will create new master.info and relay-log.info files. BecauseRead More →