I still have this problem with replication, and i dont know how to fix it. I have a slave that has been running for a long time without any problems, but now its not replicating any more. So I tried to do a "LOAD DATA MASTER;" which always gives me this error now:
Version: '4.0.15-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 031008 15:07:59 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at position 357019 031008 15:08:14 Slave I/O thread exiting, read up to log 'mysql-bin.006', position 357019 031008 15:08:14 Couldn't fix table with quick recovery: Found wrong number of deleted records 031008 15:08:14 Run recovery again without -q 031008 15:08:14 Note: Retrying repair of: './otamanager/otafrontenduser' with keycache 031008 15:08:14 Couldn't fix table with quick recovery: Found wrong number of deleted records 031008 15:08:14 Run recovery again without -q 031008 15:08:14 Note: Retrying repair of: './otamanager/profile' with keycache 031008 15:08:16 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at position 357019 I have tried to do a "REPAIR TABLE otafrontenduser,profile EXTENDED;" but no success (its says ok, but the replication does still not work). I have attached my "SHOW SLAVE STATUS;" from the problem machine. I have tried dropping the database, rebooting the machine, and creating a new database, no success. Please let me know if I need to supply more info, I have no idea on what to do next. Med venlig hilsen/Best regards Søren Neigaard System Architect ................................ Mobilethink A/S Arosgaarden Åboulevarden 23, 4.sal DK - 8000 Århus C Telefon: +45 86207800 Direct: +45 86207810 Fax: +45 86207801 Email: [EMAIL PROTECTED] Web: www.mobilethink.dk ................................
+--------------+-------------+-------------+---------------+-----------------+---------------------+-------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+------------+------------+--------------+---------------------+-----------------+ | Master_Host | Master_User | Master_Port | Connect_retry | Master_Log_File | Read_Master_Log_Pos | Relay_Log_File | Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | Exec_master_log_pos | Relay_log_space | +--------------+-------------+-------------+---------------+-----------------+---------------------+-------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+------------+------------+--------------+---------------------+-----------------+ | 172.16.1.103 | dba | 3306 | 60 | mysql-bin.037 | 11894440 | waspstat1-relay-bin.001 | 4 | mysql-bin.037 | Yes | Yes | | | 0 | | 0 | 11894440 | 4 | +--------------+-------------+-------------+---------------+-----------------+---------------------+-------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+------------+------------+--------------+---------------------+-----------------+
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]