Mysql Error when creating table: Tablespace for table `tablexx` exists. Please DISCARD the tablespace before IMPORT.

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: