Re: Replication fails on slave (missing relay log)
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.
Subject
Views
Written By
Posted
9130
July 02, 2008 02:14AM
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.