Hi, yesterday I installed the 4.0.20 binaries, compiled with Intel C++ Compiler from mysql.com.
I tried to transfer one of our (small) databases from the production-system (4.0.20 gcc binaries installed) to the test-system and came across the following problem: I did a "mysqldump --opt ... | mysql ...". The command finished without error, but no data has been transfered. I checked several scenarios and got the following results: - Without extended inserts, the transfer is ok - Just doing the extended insert fails, but reducing the size of the extended insert worked. I think, this issue has already been reported (http://bugs.mysql.com/bug.php?id=4031) - When using "mysqldump --opt ..." with a really small table (just 2 records), it didnīt transfer the data, but when I removed the "ALTER TABLE <tablename> DISABLE KEYS;" statement at the beginning of the dump-file (and the corresponding one at the end) it worked. Any ideas? Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
