When creating a table in a local database, the following error occurred unexpectedly, saying that the table already exists

However, when you view the table information through DESC, you say that the table does not exist

Searching for the table name in the local system, we found an. IBD file [InnoDB file]

After deleting the. IBD file, there is no problem to recreate the table

reference resources:

The MySQL InnoDB table space is occupied, and the table with the same name cannot be created or imported

Error: table space for table ‘database’. Temp ‘exists. Please discard the table space before import

MySQL data file description

InnoDB File-Per-Table Tablespaces

Similar Posts:

• MySQL exclude error 1114 holmium HY000 41 holmium“
• [Solved] Plugin ‘FEDERATED’ is disabled. /usr/sbin/mysqld: Table ‘mysql.plugin’ doesn’…
• Incorrect key file for table [How to Solve]
• mysql: [Err] 1075 – Incorrect table definition; there can be only one auto column and it must be d…
• Ora-01653: table a cannot be extended by 1024 (in table space ABC)
• How to Solve Mysql Error 1206: The total number of locks exceeds the lock table size
• Unknown system variable ‘storage_engine’
• [Err] 1214 – The used table type doesn’t support FULLTEXT indexes
• [Solved] MYSQL ERROR 1290 (HY000): The MySQL server is running with the –secure-file-priv option so it cannot e…
• Data truncation: Data too long for column ‘****’