https://wiki.schwatke.de/index.php?action=history&feed=atom&title=Schr%C3%B6dingers_table
Schrödingers table - Versionsgeschichte
2026-07-04T21:45:50Z
Versionsgeschichte dieser Seite in Wiki
MediaWiki 1.28.0
https://wiki.schwatke.de/index.php?title=Schr%C3%B6dingers_table&diff=1610&oldid=prev
Chris am 13. Dezember 2016 um 10:39 Uhr
2016-12-13T10:39:42Z
<p></p>
<p><b>Neue Seite</b></p><div>After removing inno db frm and ibd files from mysql /var/lib/mysql/...<br />
<br />
try to create new table <br />
<br />
Traceback (most recent call last):<br />
File "data2geoserver_1hz.py", line 28, in <module><br />
) ENGINE=InnoDB DEFAULT CHARSET=latin1;')<br />
_mysql_exceptions.OperationalError: (1813, "Tablespace '`geoserver`.`ers2`' exists.")<br />
<br />
solution:<br />
<br />
DROP TABLE my_table;<br />
<br />
ALTER TABLE my_table DISCARD TABLESPACE;<br />
<br />
rm my_table.ibd<br />
<br />
CREATE TABLE IF NOT EXISTS my_table (...)</div>
Chris