I am having very strange problems with the slave not replicating master data
but the slave’s log matches the master’s at all times.
I am running mysql 4.0.9 on a Win XP Pro (Master) and Win XP Home (Slave).
Here is my procedure for setting up the replication:
Initially both the master and slave server are shut down.
1. Delete all err, log and master files on both master and slave.
2. Start the master server.
3. create the database and tables on the master server.
4. Now I load some data into the master tables. I load 3 rows into a table.
5. Show master status and record the offset.
6. Flush tables with read lock on the master.
7. Zip up the database folder.
8. Unlock tables on master. (No other writes are being performed because I
am the single user)
9. Unzip database on the slave.
10. Start the slave server (not the thread).
11.Execute the Change Master to on the slave with the log offset from the
master.
12.Start the slave thread with “slave start”.
13.Show slave status…do a select on the table….everything looks fine….the 3
rows are there.
14.Now, here is the weird part: I insert some more rows into the master
table. This should now be replicated...right?
I do a “show master status” and a show slave status….the master log position
on both slave and master are identical and have moved forward to the same
position….HOWEVER, no new data has been inserted into the slave table! I
look in the slave-relay-bin.xxx log and the inserts are there...but no data
in the slave table other than what was unzipped along with the initial
database structure?! Both error logs report no errors.
What is going on? Anyone? Am I doing something out of order?
Also, I understand I can use LOAD DATA FROM MASTER since I am using version
4+. Where in this procedure should that call be made on the slave so that
everything works fine. The MySQL docs are very vague as to where exactly in
all this that command should be issued.
Thanks for any help.
_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
---------------------------------------------------------------------
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
