Philip, the problem is probably that the table already exists in the InnoDB internal data dictionary. With 4.0.17, I get:
mysql> CREATE TABLE ids (id varchar(255)) TYPE=InnoDB; ERROR 1005 (00000): Can't create table './test/ids.frm' (errno: 121) mysql> Output to the .err log: 031112 17:48:39 InnoDB: Error: table test/ids already exists in InnoDB internal InnoDB: data dictionary. Have you deleted the .frm file InnoDB: and not used DROP TABLE? Have you used DROP DATABASE InnoDB: for InnoDB tables in MySQL version <= 3.23.43? InnoDB: See the Restrictions section of the InnoDB manual. InnoDB: You can drop the orphaned table inside InnoDB by InnoDB: creating an InnoDB table with the same name in another InnoDB: database and moving the .frm file to the current database. InnoDB: Then MySQL thinks the table exists, and DROP TABLE will InnoDB: succeed. InnoDB: You can look further help from section 15.1 of InnoDB: http://www.innodb.com/ibman.html Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL support from http://www.mysql.com/support/index.html ................... List:MySQL General Discussion« Previous MessageNext Message » From:Philip MolterDate:November 12 2003 4:44pm Subject:Cannot create InnoDB table 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/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
