Schrödingers table

After removing inno db frm and ibd files from mysql /var/lib/mysql/...

try to create new table

Traceback (most recent call last):
 File "data2geoserver_1hz.py", line 28, in <module>
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;')
_mysql_exceptions.OperationalError: (1813, "Tablespace '`geoserver`.`ers2`' exists.")

solution:

DROP TABLE my_table;

ALTER TABLE my_table DISCARD TABLESPACE;

rm my_table.ibd

CREATE TABLE IF NOT EXISTS my_table (...)