Sqlyod Corrupt Hidden Table

[becky]

Hello There,

 

Pls can any one help me urgently?

 

I have a table created in mySQL database and I use the SQLyog as client.  Now the problem is some of my tables are corrupted but they are hidden.  I cant see them, mean while when I try to create a new one I receive a message ” The table already exist”.

 

Please, how can I delete the existing one and create a new one? 

 

Thank you for your assistance.

[peterlaursen]

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? 

[Author]

Posts