mysql> SHOW PROCESSLIST\G
Id: 2
User: system user
Host:
db: NULL
Command: Connect
Time: 80
State: Waiting for master to send event
Info: NULL
Id: 3
User: system user
Host:
db: NULL
Command: Connect
Time: 192
State: Has read all relay log; waiting for the slave I/O thread to update
it
Info: NULL
I have authorized all privilege to repl@'%' in master and slave since we
liketo access the database (no change, just some query to display what's
ondatabase across network). It shouldn't matter to replication?-----
Original 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 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.
>
> Do you use any replicate-* options?
> What is the output of SHOW PROCESSLIST command on the slave?
>
>
>
> --
> 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]
