MySQL table

[MIPreston]

I was repairing MySQL table when suddently server hanged and when I returned back all tables are ok but this one showing me an error message: InnoDB: have deleted and recreated InnoDB data files but have forgotten.

I tried to search from google but no answer.

Any help would be appriciated.

 

[zzip]

I was repairing MySQL table when suddently server hanged and when I returned back all tables are ok but this one showing me an error message: InnoDB: have deleted and recreated InnoDB data files but have forgotten.

I tried to search from google but no answer.

Any help would be appriciated.

 

 

Did you delete the filesystem files associated with the table? If you didn't, are they gone? (does the table work?)

Did the filesystem run out of space, by chance?

[luna028]

The problem may be due to name completion in the mysql client. To work around this problem, start the MySQL client with the --skip-auto-rehash option and try DROP TABLE again. (With name completion on, MySQL tries to construct a list of table names, which fails when a problem such as just described exists.) If you are still have the problem you may apply this one solution https://www.repairtoolbox.com/mysqlrepair.html

 

Good luck