mysql:failed to open the relay log solution

See the solution below

The log logs are turned on for the following reasons:

111121 15:15:22 [ERROR] Failed to open the relay log './dong-relay-bin.000002′ (Relay_log_pos 1067)

111121 15:15:22 [ERROR] could not find target log during relay log initialization

You can do this in the following ways:

1. Stop MySQL Service

2, in the MySQL log directory to delete all the relay logs, including Hostname-relay-bin.xxx, Hostname-relay-bin.index and Relay-log.info and so on

3, restart the MySQL service

This way, MySQL will regenerate the relay log.