"Liying Huang" <lhuang@stripped> wrote:
> I tried to do replication from master-> slave, I used windows,
> MySql 4.0.17 version on both. I have set bin-log option
> in my.cfg in master computer, set master-host, master-user, master-password,
> replicate-do-db and replicate-ignore-db=mysql, skip-slave-start in
> my.cfg in slave. I have zipped the database from master, copy the zip to
> slave and unzip it, then I start both server, start slave. When I do some
> update in master computer in database, the query showed in master-bin.001
> and it is shown in slave-relay-bin.001 too (slave IO thread seems working),
> but database in slave doesn't update. What have I done wrong? The database
> not small, it will take forever if I use 'load data from master', so I
> copy the database instead. The outcome from "Show processlist\G"
> is attached below too. It seems slave SQL thread is running without problem.
If you use replicate-do-db=db_name option, only queries for which db_name is current
database will be replicated.
For example, the following INSERT statement will not be replicated:
INSERT INTO db_name.table_name VALUES(..);
Do you specify database name explicitly in the queries?
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net