Posted in Hosting & IIS7 | No Comment | 2,939 views | 03/05/2011 22:10
If you face with a MySQL replication issue, you should restart it with command line.
First of all, stop MySQL services and replicate latest MySQL data files. After that, you can start services again.
Go to Slave and execute:
You can get Master_Log_File and Master_Log_Pos with executing “SHOW MASTER STATUS;” on Master MySQL.
If you want to see replication status again, execute:
I don’t know any better way. If you have one, please reply :)