Try (assuming that it is OK that you lose the data in the corrupted tables)
1) execute “DROP TABLE tablename;” from the SQLyog editor. You may of course also try to repair them first (“REPAIR TABLE tablename;”). Ensure the correct defaltdatabase (exectuea USE statement or select the database in SQLyo Object browser.
2) If tables are MyISAM tabs and if you have access to the file system on the server, delete or rename files “tablename.frm”, “tablename.MYD” and “tablename.MYI” for affected tables. DO NOT attempt something similar with InnoDB tables!
3) Dump the entire database, DROP the database and reimport the dump. Dependng on what exactly the problem is, this could ‘clean up’ hidden tables (as they will most likely not be included in the dump).
if you have access to do so, I suggest that you stop the MySQL server and make a copy of the complete data folder first.
Any idea how the tables could corrupt like that?
