I have set master database ( version 5.0.21) and slave database ( 5.0.24a)
to replicate database db1. When database on master is modified changes do
get replicated to the replication relay bin file on slave but they do not
get applied to the database.
Here is section of my.cnf on master.
Here is section of my.cnf on slave.
Here is the output of show slave status \G;
Slave_IO_State: Waiting for master to send event
When db1 is modified on master, Read_Master_Log_Pos and Relay_Log_Pos do
changes, also I can open and see the changes in rh3-relay-bin.000002, but
they do not appear in database. No error logged in /var/lib/mysql/rh3.err
Replicate_Do_DB is showing database name twice. I am not sure why.
Any and every help appreciated.
|• Replicate_Do_DB shows duplicate name||Sudhir Damle||30 Oct|