InnoDB: The file '.table.ibd' already exists issue

[Alex Mansour]

Hi, 

We have Google SQL Cloud Instance and we have a problem with InnoDB MySQL DB. Frequently we drop this DB Tables and we Import newly SQL Dump File, recently we started to get this error: "4435 [ERROR] InnoDB: The file './table.ibd' already exists though the corresponding table did not exist in the InnoDB data dictionary."

Any thoughts we started to receive this error recently? And how we can solve it? We tried to locate the .ibd files and delete them but we were not able to find them.

Thanks for the help in advance. 

Note: The Drop and the Import of the tables process is done manually via MySQL queries and not via SQL Cloud Instance API. 

[nau...@google.com]

Hello Alex,

From the description and the error message, it seems like a case-specific problem with the MySQL.

I was able to find this report with a similar error you are encountering. For more information on InnoDB File-Per-Table Tablespaces, you can refer to this MySQL documentation. 

However, this seems like a question that would be better posted to DBA stackexchange and  MySQL forum  where you have access to a larger community of database enthusiasts and experts to share ideas with and get support from. Make sure to include all relevant details and error messages which would help the community troubleshoot.