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.
On Saturday, January 6, 2018 at 5:16:53 PM UTC-5, Alex Mansour wrote:
-- 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.
On Saturday, January 6, 2018 at 5:16:53 PM UTC-5, Alex Mansour wrote:
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.
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/c75d3f48-6e78-4efc-b06c-8468fb6d2eb8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment