OS: RedHat 6.2 on master and slave
mySQL: 3.23.32 on master and slave
Problem: Replication is not working. Symptoms include:
* Connecting OK. 'Show slave status' reports nominally.
* Position on the log file increments correctly when updates occur on the
master.
* The tables do not get updated.
The web hosting service (20after4.com = recommended - very helpful people
there) has performed a replication between two of their servers, using the
same master for my replication attempt as the master for theirs. Their
replication worked.
The main difference is that they did not use redirection and I did. Having
the development database on this system, I do not want to replicate
directly. So, when we synced I created a local database here (xxxprod),
copied the snapshot of the production database to the xxxprod data directory
here, then initiated replication.
We have tried putting the replication commands in the my.cnf file and using
the 'change master to' command, and get the same results. Here is the
current my.cnf file.
[mysqld]
server-id=111111
replicate-do-db=xxx
replicate-rewrite-db=xxx->xxxprod
Anyone have an idea what we may have done wrong?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
