469,283 Members | 2,303 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,283 developers. It's quick & easy.

Replication Setup

Am attempting to setup master/slave replication in Windows environment. Both
master and slave are running WinXP. Master appears to be logging correctly,
but cannot get slave to update its databases and tables from the master.
MySQL 4.1.10a-nt is running on the master. MySQL 4.1.7-nt is running on the
slave.

Only workgroups are used on LAN, no domain.

my.ini on master, section [mysqld], has following inserted statements:

log-bin=mysql-bin
server-id=1

After database activity, data directory on master includes files
mysql-bin.000001 at 748,290 bytes, and mysql-bin.index at 19 bytes.

my.ini on slave, section [mysqld], has following inserted statements:

server-id=2
master-host=calvados
master-user=repl
master-password=repl_pass
replicate-do-db=dbname1
replicate-do-db=dbname2
log-warnings

Note "calvados" is the network name for the master. For test purposes, am
literally using username "repl" and password "repl_pass". "dbname1" and
"dbname2" correspond to valid databases on the master, that were logged in
mysql-bin.000001, and that do not exist on the slave.

Running mysql.exe on the slave, commands

start slave;
load data from master;

both respond with "Query OK, 0 rows affected".

"Show databases" on the slave then reveals the standard two databases
"mysql" and "test", but no "dbname1" nor "dbname2".

What am I doing wrong? What logs should I consult? Thanks.
Jul 23 '05 #1
0 1013

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Cherrish Vaidiyan | last post: by
reply views Thread by Cherrish Vaidiyan | last post: by
1 post views Thread by Andy K | last post: by
9 posts views Thread by ibm_97 | last post: by
8 posts views Thread by sat | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.