My mysql service is currently unable to start with the error

InnoDB: Could not find a valid tablespace file for 'wowcher/temp_import'.

I think I know what the issue is. I have a PHP script which imports CSV files into a temporary table before splitting information to the correct relevant tables.

It would then wipe the temporary table at the end of the script, however for some reason it has been giving errors before completing and wiping the table. So Im pretty sure the temp table is huge right now.

How can I wipe it when I cannot start the mysql service? or is it something else that is causing the problem?

1 Answer 1


In the mysql data folder look for *.frm and *.ibd files for the temp table. Remove them manually and then start.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .