Over the weekend, one of our MySQL databases has suffered some errors and I'm trying to restore from backup but can't do it as the existing database is missing tables and won't let me remove the corrupt database.
The Windows Server 2003 event logs report the following:
Event ID: 100
Description:
Cannot find table 'database1/table_name' from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database?
Using PhPMyAdmin if I click the table names I get the following error "#1146 - Table 'database1.table_name' doesn't exist"
If I try to delete or drop the Database via PhPMyAdmin I get the error "#1051 - Unknown table..." giving a list of tables that it can't find.
I'm stuck here as I can even do restore from an earlier backup.
Hoping someone can help with this. Thanks
The Windows Server 2003 event logs report the following:
Event ID: 100
Description:
Cannot find table 'database1/table_name' from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database?
Using PhPMyAdmin if I click the table names I get the following error "#1146 - Table 'database1.table_name' doesn't exist"
If I try to delete or drop the Database via PhPMyAdmin I get the error "#1051 - Unknown table..." giving a list of tables that it can't find.
I'm stuck here as I can even do restore from an earlier backup.
Hoping someone can help with this. Thanks