Hi everyone, Replication has been working OK for me for the last month or with mysql 3.23.38, however following a crash I am having a lot of problems. This is happening constantly: replication will work for a while and then stop with the following: mysql> show slave status; | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | |Last_error | | | Skip_counter | | unisondb1.internal.nw | repl | 3306 | 60 | |unisondb1-bin.001 | 20887103 | No | | || 1016 | error 'Can't open file: 'stories.MYD'. (errno: 145)' on query 'INSERT |into stories(issue_id,category_id,rank,story_content_id,dated,timed,valid_until) values('39','38','3','443498','2001-07-05','17:15:25','2001-07-15')' | 0 | error 145 indicates that the table has a problem and needs to be repaired. However, I have no problem in running the sql manually! So, off I go and do a bunch of myisamchks on the table with every incantation I can think of, all showing no problems at all. I have tried going through the binlog on the master manually adding each bit of sql that fails (always on this one table) - which has worked before - and eventually the slave thread fires up again. Any ideas at all would be much appreciated. Many thanks, John. -- [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php