I am trying to get replication going for two specific databases on my master machine which currently houses 3 databases.
My Server is running MYSQL 5.0 on a Windows 2003 server box 32 bit.
Anyhow I dumped my two databases seperately using mysqldump. The command line used was as follows.
mysqldump --username=root --password --databases db1name --master-data --hex-blob >db1name.sql
mysqldump --username=root --password --databases db2name --master-data --hex-blob >db2name.sql
These were also restored separately into the slave.
I set the my.ini file with the following..
After doing this, when I show master status, the log pos never moves. If i remove the .ini entries, the position moves. On the slave it is only replicating DB2 and not DB1.
I tried adding the following to the slave ini....
This has not resolved the issue. Please help :)