Massi,
You will get much better results if you provide the following:
Copies of:
my.cnf file from both master and slave
(look in $MYSQL/data or /etc)
$HOSTNAME.err logs from master and slave
master.info file from slave
(look in $MYSQL/data directory)
and check that one does not exist on the master, this gave me fits for
several hours one day while moving a slave to being the master when the
then current master died of a bad hard drive.
No guarantees, but this will greatly improve your chances of an
intelligent answer. ;p
Scott Helms
On Mon, 2003-03-31 at 17:04, trashMan wrote:
> The error.log on the master dont' report anything...
>
> MySql: ready for connections
>
> Other info
>
> >Show master status;
>
> *******************************************
> Header answer note
> *******************************************
> File webserver-bin.008
> Position 73
>
>
>
> >SHOW PROCESSLIST
>
> ***************
> Header answer
> ***************
> User userreplica
> Host XXXXX
> Db NULL
> Command Binlog dump
> Time XXXX (the time passed from the mysql
> start)
> Query connect
> Time XXXX (the time passed from the mysql
> State slave connection: waiting for binlog update
>
>
> :-/
>
> Massi
>
>
>
>
>
> -----Messaggio originale-----
> Da: Jennifer Goodie [mailto:[EMAIL PROTECTED]
> Inviato: lunedì 31 marzo 2003 23.41
> A: trashMan; [EMAIL PROTECTED]
> Oggetto: RE: Replication don't work.
>
>
> It the master actually writting to the binlog? What does the master say
> when you run SHOW MASTER STATUS? Is the size of the binlog growing?
>
> -----Original Message-----
> From: trashMan [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2003 1:29 PM
> To: [EMAIL PROTECTED]
> Subject: Replication don't work.
>
>
> There are two weeks i try it...but...the replication don't start!!
>
> I've follow the istruction
> http://www.mysql.com/doc/en/Replication_HOWTO.html without success.
>
> In the slave i have:
>
> >Show slave status;
>
> *******************************************
> Header answer note
> *******************************************
> Slave_Running YES
> Last_Error none
>
>
> >SHOW PROCESSLIST
>
> ***************
> Header answer
> ***************
> User system user
> Host none
> Db NULL
> Query connect
> Time XXXX (the time passed from the mysql
> start)
> State Reading master update
>
>
> I think the database is in updating...but the table are the same....i
> don't have new data!! What can i do??? :-(
>
> Help!
>
> Massi
>
>
>
> --
> 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]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
