I've a problem that I can't drop a certain table, always get back the error "unknown table".
Version: 4.0.21 (Debian Testing)
Table-Type: InnoDB
mysql> show tables;
[...]
| produkt_kategorie |
mysql> drop table produkt_kategorie;
ERROR 1051: Unknown table 'produkt_kategorie'
The ownerships/permission seem right to me too:
-rw-rw---- 1 mysql mysql 8670 Sep 21 11:23 produkt_kategorie.frm
mysql> describe produkt_kategorie;
| Field | Type | Null | Key | Default | Extra |
+--------------+------------------+------+-----+---------+----------------+
| pk_id | int(10) unsigned | | PRI | NULL | auto_increment |
| pk_pt_id_typ | int(10) unsigned | | MUL | 0 | |
| pk_kategorie | varchar(255) | YES | | NULL | |
| pk_sortid | int(10) unsigned | YES | | NULL | |
pk_pt_id_typ is from a 1:n relation to the table produktkategorie_typ.
I do the operation as user 'root' which has all access-rights.
When I view the table in phpmyadmin (using 2.5.7pl1) I also see this additional information:
InnoDB free: 44032 kB; (`pk_pt_id_typ`) REFER `produktkategorie_typ`(`pt_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
I've used DbDesigner4 to design the table and then use the synchronisation feature to create the tables in the database.
I'm using a 1:n relation from another table, produktkategorie_typ, to this table. I've created the Reference Definitions, but yet haven't assigned any actions (thus there's NO ACTION defined as seen above).
I believe it has to do with the relation/reference definitions from InnoDB, so to me the message seems missleading.
The only way for me to drop the table is to completely drop the database and recreate.