Can't restart slave - Could not initialize master info structure

[Rasmus U]

Hi, I've set up replication for backup/logging/statistics purposes. Everything is working okay, EXCEPT if the slave server i down more than a few hours/days, I can't restart the slave process.

The error message is
ERROR 1201 (HY000): Could not initialize master info structure;

and

[ERROR]Failed to open the relay log '/var/run/mysqld/....'
[ERROR] Could not find target log during relay log initialization

As I understand, the logs get flushed after prolonged downtime/reboot.

Is it any way I can configure the slave server, so that it'll catch up with the master server, without me having to get a new snapshot/master position etc (which is a cumbersome process). - The slave already knows the last position it has reached at the master, so I do not understand the significance of the relay log...

Does it make a difference whether the slave is STOPped before stopping the mysqld service?

Thanks for your help!



Edited 1 time(s). Last edit at 04/23/2009 07:03AM by Rasmus U.