Re: How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?

Am 19.06.2013 21:00, schrieb Franck Dernoncourt: > `USE logs; SHOW TABLES;` does not list the table `logs/#sql-ib203`, but > when trying to `ALTER` the table that was being changed during the crash > MySQL complains about the existence of the table `logs/#sql-ib203`: > >> ERROR 1050: Table 'logs

How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?

Hi all, A table `logs/#sql-ib203` appeared after a MySQL crash due to disk space shortage while deleting some attributes in a table in the `logs` database and adding an index. `USE logs; SHOW TABLES;` does not list the table `logs/#sql-ib203`, but when trying to `ALTER` the table that was being c