Knowledgebase

Database Restore Failed - Please DISCARD the tablespace before IMPORT

When restoring databases JetBackup attempts to drop the database tables before starting the restoration. This can sometimes result in the following error:

[ERROR] ERROR 1813 (HY000) at line 25: Tablespace for table TABLENAME exists. Please DISCARD the tablespace before IMPORT

This error often occurs if the database table files still exist in the MySQL folder or are cached. Here are a few resources that may assist with this issue:

https://www.24x7servermanagement.com/clients/index.php?rp=/knowledgebase/106/ERROR-Tablespace-for-table-exist.-Please-DISCARD-the-tablespace-before-IMPORT..html https://stackoverflow.com/questions/15694168/error-tablespace-for-table-xxx-exists-please-discard-the-tablespace-before-impOnce the cache has been cleared of all instances of the TABLE, the restore should continue with no issues.