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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 > '[EMAIL PROTECTED]: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 > '[EMAIL PROTECTED]: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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
