I have just upgraded my test server to MySQL 4.0.0 from MySQL 3.23.44 There is a 2Gb table with 2286869 records which I can query fine on MySQL 3.23.44, but when I change over to MySQL 4 if I try and INSERT or REPLACE any records it keeps saying 'Duplicate entry' and when I do an UPDATE, it corrupts the table. When I put MySQL 3.23.44 back on the same table & try REPLACE, INSERT or UPDATE - it works fine again. Any ideas?
cheers --------------------------------------------------------------------- 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