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..htmlOnce the cache has been cleared of all instances of the TABLE, the restore should continue with no issues.
https://stackoverflow.com/questions/15694168/error-tablespace-for-table-xxx-exists-please-discard-the-tablespace-before-imp
