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

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.

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.

Restarting MySQL works fine for me.