Recovering MySql Database After WAMP Removal?

Question

I deleted WAMPon Win7. He deleted everything, but saved the data folder containing my database. After installing WAMP again in the same directory, I thought it would restore the database MySQL, but it is not.

He shows me my database, and when I expand it in phpMyAdmin, I can see the tables, but when I try to query them, he says:#1146 - Table 'tablename' doesn't exist

I searched and found a couple of posts. This post is close enough, but for Linux it's not really my business.

Any help would be appreciated.

UPDATE 1: I tried to repeat the steps described here

• MySQL service is stopped,
• Renamed old database directory,
• Launched the MySQL service,
• Created a new database with the same name and replaced all database files on it

Still getting the same error.

UPDATE 2: I tried to repeat the steps mentioned here are still having the same error.

UPDATE 3: Examining the .err file showed the error below:

[Warning] InnoDB: Cannot open table testdb/rules from the internal data dictionary of InnoDB though the .frm file for the table exists.

UPDATE 4: CHECK TABLE tablename ;led to the following errors

Warning InnoDB: Tablespace is missing for table 'db/tablename'
Error   Table 'db.tablename' doesn't exist
status  Operation failed

Answer 1

Why do not you delete and reinstall WAMP with backup data files in the data directory. sometimes it solves the problem.

I suggest that you always export your database before making any major changes.