MySQL Forums
Forum List  »  InnoDB

Re: InnoDB corruption, "table ... doesn't exist"
Posted by: Brian Edwards
Date: January 25, 2018 02:00PM

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.

Options: ReplyQuote

Written By
Re: InnoDB corruption, "table ... doesn't exist"
January 25, 2018 02:00PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.