Issue:
When trying to restore a database (“poller” used as an example), you may receive this error:
D:\mysql poller < poller.sql
ERROR 1813 (HY000) at line 25: Tablespace for table '`poller`.`interfaces_snmp`' exists. Please DISCARD the tablespace before IMPORT.
Environment:
NFA 9.3.2+
Cause:
This is because the database restore steps were done improperly. You can’t stop services and delete the files in the database folders (installdir\MySql\data\databaseName) in NFA 9.3.2+ and restore a database like NFA 9.3.1 and priot because of the new innoDB features in MySQL. For more information on how to properly backup and restore from the start in NFA 9.3.2+, please see TEC1029127. If you are already at this point and received the above error please see the solution below.
Resolution/Workaround:
Additional Information:
TEC1029127 for more information on innoDB and how to properly backup and restore databases on NFA 9.3.2+.