My production db crashed and I have 5 very large partitioned tables. The active partitions are from the 14th on. The DB is up but 5 tables “do not exist” when trying any commands i.e. DESC tbl1;
InnoDB: Table xyz in the InnoDB data dictionary has tablespace nnnn, but tablespacewith that id or name does not exist.
I can see the row in information_schema.innodb_sys_tables for the orphaned partition.
I cannot do any operations against the tables because MySQL thinks they do not exist.
Is there a way to clean this up?
My prod DB is down at this time…