Bug? #1146 - Table 'xxx.xxxxx' doesn't exist

Question

I am using windows XP. I am creating a table in phpMyAdmin using its built-in create table feature, my database name is ddd.

It generates the following code:

CREATE TABLE  `ddd`.`mwrevision` (  `asd` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `sddd` INT NOT NULL ) ENGINE = INNODB; 

and the following error shows up:

MySQL said:      #1146 - Table 'ddd.mwrevision' doesn't exist  

What might be the problem?

Answer 1

I also had same problem in past. All had happend after moving database files to new location and after updating mysql server. All tables with InnoDB engine disappeared from my database. I was trying to recreate them, but mysql told me 1146: Table 'xxx' doesn't exist all the time until I had recreated my database and restarted mysql service.

I think there's a need to read about InnoDB table binaries.

Answer 2

I had the same problem and can't get a good tip for this over the web, so I shared this for you and for all who needs.

In my situation I copy a database (all files: frm, myd) to the data folder in MySQL data folder (using Wamp at home). All thing was OK until I want to create a table and have the error #1146 Table '...' doesn't exist!.

I use Wamp 2.1 with MySQL version 5.5.16.

My solution:

1. Export the database to file;

2. verify if exported file is really OK!!;

3. drop the database where I have issues;

4. create a new database with the same name that the last;

5. import the file to the database.

FOR ME IS PROBLEM SOLVED. Now I can create tables again without errors.