Re: InnoDB corruption, "table ... doesn't exist"
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.
Subject
Views
Written By
Posted
3978
January 23, 2018 12:50PM
1287
January 23, 2018 01:08PM
982
January 23, 2018 01:32PM
706
January 23, 2018 01:33PM
884
January 23, 2018 02:22PM
747
January 24, 2018 10:56PM
636
January 25, 2018 09:57AM
804
January 25, 2018 12:17PM
Re: InnoDB corruption, "table ... doesn't exist"
852
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.