MySQL Forums
Forum List  »  Replication

Re: Can't restart slave - Could not initialize master info structure
Posted by: Rasmus U
Date: April 30, 2009 04:42AM

Rick James Wrote:
-------------------------------------------------------
> Sounds like you are replicating from yourself:
> Master_Host: localhost

No, the slave connects to the master over a ssh tunnel

:-D

Anyway, this is how I am going to try to safely stop slave:
STOP SLAVE;
SHOW SLAVE STATUS;
- make note of Master_Log_File, Read_Master_Log_Pos (possibly Exec_Master_Log_Pos)
RESET SLAVE; - delete all logs, reset everything
- stop mysqld/reboot
then
CHANGE MASTER TO ... with the values from above inserted

Is this the only safe solution?

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.