How to fix MySQL ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository

Shutdown MySQL slave
Open the index file and remove all of the lines referring to
non-existing relay log files. Then save.

  sudo su - -s /bin/bash mysql
  vim db6--relay-bin.index

Start MySQL slave again.
Now execute RESET SLAVE ALL followed by the CHANGE MASTER TO statement
to setup replication again.

Comments

Popular posts from this blog

Check MySQL query history from command line

Installing chocolatey on Windows

Fixed: ImportError: No module named utilities.common.tools