Hi, can you indicates your configuration about : - my.cnf - all tables type your using in the master (MyISAM, INNODB, BDB)
This may help to see what goes wrong . Regards Thierno 6C - MySQL 4.0.15 ----- Original Message ----- From: "Søren Neigaard" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 09, 2003 1:32 PM Subject: What is wrong with this bloody MySQL? I have posted the message with the subject "Serious problem with replication", but nobody seems to know what to do? Now I have even tried to completly uninstall MySQL (with rpm -e), delete the "/var/lib/mysql" dir, and reinstall MySQL with "rpm -i MySQL-server-4.0.15-0.i386.rpm". Then I create my database, create the tables, set up replication (as slave), and do a "LOAD DATA FROM MASTER;", and still I get this bloody error: Version: '4.0.15-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 031009 15:33:48 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at position 1408472 031009 15:34:33 Slave I/O thread exiting, read up to log 'mysql-bin.006', position 1408472 031009 15:34:33 Couldn't fix table with quick recovery: Found wrong number of deleted records 031009 15:34:33 Run recovery again without -q 031009 15:34:33 Note: Retrying repair of: './otamanager/otafrontenduser' with keycache 031009 15:34:33 Couldn't fix table with quick recovery: Found wrong number of deleted records 031009 15:34:33 Run recovery again without -q 031009 15:34:33 Note: Retrying repair of: './otamanager/profile' with keycache 031009 15:34:36 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at position 1408472 Is there really nothing to do here, what the hell is the problem with MySQL? 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 ................................ -- 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]