To debug the problem. Make "SHOW SLAVE STATUS" in the slave and check for
the error number..
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.gittigidiyor.com & http://www.dalar.net
----- Original Message -----
From: "Nico Sabbi" <nsabbi@stripped>
To: <mysql@stripped>
Sent: Monday, July 12, 2004 6:08 PM
Subject: Replication stopping
> Hi,
> often my slave suddenly stops, reporting these the logs:
>
>
> 040712 12:19:00 Slave I/O thread exiting, read up to log 'db-bin.3323',
> position 197564621
> 040712 12:19:10 Slave I/O thread: connected to master
> 'replica@master:3306', replication started in log 'db-bin.3323' at
> position 197564621
> 040712 13:48:22 Slave I/O thread exiting, read up to log 'db-bin.3323',
> position 208931388
> 040712 13:48:25 Slave I/O thread: connected to master
> 'replica@master:3306', replication started in log 'db-bin.3323' at
> position 208931388
>
> this is the configuration of the slave:
>
>
> [mysqld]
> log-bin
> server-id=20
> master-host=master
> master-port=3306
> master-user=replica
> master-password=***********
> replicate-ignore-db=mysql
>
> replicate-wild-do-table=db1.prc
> replicate-wild-do-table=db2.provincia_rc
> replicate-wild-do-table=db3.tc
> replicate-wild-do-table=prc.%
>
> master-connect-retry=60
> slave-skip-errors=all
>
>
> How can I understand exactly what is stopping the replication?
>
> Thanks,
> Nico
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
