MySQL Forums
Forum List  »  Replication

Re: Replication fails on slave (missing relay log)
Posted by: Armand Krijgsman
Date: July 04, 2008 04:50PM

Oke, this is how I fixed it at the end. Started with a whole new clean replication slave.

1. stop mysql server on the replication machine.
2. deleted all the files in my /var/log/mysql/ directory
(replication files and indexes where located here.)
on the replication machine
3. comment all the replication linex in my.cnf
4. start mysql server, comes up as normal server.
5. remove all the databases.
6. make a mysqldump backup from the master and copy it to the slave.
make sure you request a "show master status" command on the master for binlog and index information.
7. make sure you don't overwrite mysql database ofcourse :-)
9. load all the data from
8. uncomment the lines for slave in my.cnf.
9. restart mysql on the slave server.
10. you should be able to login using phpmyadmin or commandline tool, now just add the CHANGE MASTER TO MASTER_HOST command and the slave start command.

And things should be up and running again.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Replication fails on slave (missing relay log)
4062
July 04, 2008 04:50PM


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.