My replicate-do-db=db1, db2, let me make db1 to be current database to see if the query will update or not. If update, then you probably solve my problem.
Thanks. Liying ----- Original Message ----- From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 12, 2004 10:43 AM Subject: Re: question for replication > "Liying Huang" <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > 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 > > is > > 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: > > USE some_other_db; > 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 > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]