I have a situation using InnoDB where I cannot create even the most basic of tables with a given name.
mysql> create table card_batch ( a int ); ERROR 1005: Can't create table './test_gn/card_batch.frm' (errno: 121) mysql> show tables like 'card%'; Empty set (0.01 sec) mysql> show variables like 'version'; +---------------+-------------+ | Variable_name | Value | +---------------+-------------+ | version | 4.0.15a-log | +---------------+-------------+ 1 row in set (0.00 sec) In another database on the same server, using the same InnoDB files, I can create the table just fine. Why does it keep telling me that it cannot create the table because of "Duplicate key on write or update"? The MySQL version os 4.0.15a. The operating system is Solaris 9. Philip * Philip Molter * Texas.Net Internet * http://www.texas.net/ * [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
