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.
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.
TEC1029127 for more information on innoDB and how to properly backup and restore databases on NFA 9.3.2+.