Edit Question - KnowledgeHub

Title Body

I am having the weirdest error of all. Sometimes, when creating or altering tables, I get the 'table already exists' error. However, DROP TABLE returns '#1051 - unknown table'. So I got a table I cannot create, cannot drop. When I try to drop the database, mysqld crashes. Sometimes it helps to create another db with different name, sometimes it does not. I use a DB with ~50 tables, all InnoDB. This problem occurs with different tables. I experienced this on Windows, Fedora and Ubuntu, MySQL 5.1 and 5.5. Same behaviour, when using PDO, PHPMyAdmin or commandline. I use MySQL Workbench to manage my schema - I saw some related errors (endlines and stuff), however none of them were relevant for me. No, it is not a view, it is a table. All names are lowercase. I tried everything I could google - flushing tables, moving .frm files from db to db, reading mysql log, nothing helped but reinstalling the whole damn thing. 'Show tables' reveals nothing, 'describe' table says 'table doesn't exist,' there is no .frm file, yet 'create table' still ends with an error (and so does 'create table if not exists') and dropping database crashes mysql Related, yet unhelpful questions: Mysql 1050 Error "Table already exists" when in fact, it does not MySQL Table does not exist error, but it does exist Edit: mysql> use askyou; Database changed mysql> show tables; Empty set (0.00 sec) mysql> create table users_has_friends (id int primary key); ERROR 1050 (42S01): Table '`askyou`.`users_has_friends`' already exists mysql> drop table users_has_friends; ERROR 1051 (42S02): Unknown table 'users_has_friends' </cod

Tags (comma-separated) Cancel