Hi, Sasha:
I got replication working now. Thanks veryyy much for your suggestion.
Liying
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have been struggling with one way replication for weeks, still
can't make it work.
I used windows, MySql 4.0.17 version on both. I have set bin-log option
in my.cfg in master computer, in slave computer, set master-host,
master-user=repl,master-password, replicate-do-db=test and
replicate-ign
still. :<.
Liying
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Liying Huang" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, February 12, 2004 11:00 AM
Subject: Re: Re; Re: question for replication
Was the update peformed in eit
27;t get update. :<.
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
It only update WITCD. I finish the switching, query still doesn't
update in slave.
Liying
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Liying Huang" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, February 12, 2004 11:00 AM
I just use "update *** set ***" query on WITCD, Victoria might
find out the problem for me, I didn't specify database in query,
if database is not current, the query will not be updated. I
am trying to use one database to be current for both master
and slave, and see if query will update slave or
ED]>
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
Relay_log_space: 116
1 row in set (0.00 sec)
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Liying Huang" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>Sent: Thursday, February 12, 2004 10:28 AM
Subject: Re: question for replication
What is the o
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
Hi,
I have done a show processlist\G right after I start slave.
*** 1. row ***
Id: 1
User: martin
Host: localhost:1110
db: NULL
Command: Query
Time: 0
State: NULL
Info: show processlist
*** 2. row
nal Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 11, 2004 6:50 AM
Subject: Re: question about replication
> "Liying Huang" <[EMAIL PROTECTED]> wrote:
> >
> > I have tried to upgrade my
I have tried to upgrade mysql to 4.0.17 version, still
have the same problem. All queries shown in relay-bin
file at slave, but slave database is not updating. I
read documentation, but can't find helpful information
on this.
Liying
--
MySQL General Mailing List
For list archives: http://list
I only replicate the simplest, master->slave.
I used MySQL 4.0.11 version in both PCs.
Liying
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 10, 2004 5:32 AM
Subject: Re: question about repl
Hi,
I tried to create replication. I have edited my.cnf on master and slave side.
Grant necessary privileges on master side, then start both servers, when I update
the database in master side, I could see the query showed up in ***-bin.001,
and it is passed to slave side successfully, shown
14 matches
Mail list logo