Re: InnoDB corruption, "table ... doesn't exist"

[Brian Edwards]

Thank you, Peter. My guess is that you are referring to the MySQL /doc link, section "Cannot Open File Error". If that is not correct please let me know.

Most of the tables that are showing as "doesn't exist" with mysqlchk are tables I don't need anyhow (almost all are leftover from previous testing of WordPress plugins). For those I would not be worried about deleting the associated .frm files. There are some tables, however, that I know are needed, and others that I am assuming are needed, such as all of the InnoDB tables inside the default mysql database. The "instructions" in this section say "This means that there is an orphan .frm file without a corresponding table inside InnoDB. You can drop the orphan .frm file by deleting it manually." I don't know what deleting the .frm files for the tables I need to keep would do but I do have good backups so I guess it's worth a shot to delete those files and see what happens. I can't imagine good things would happen but we'll see.