note: MySQL ERROR 1050 (42S01) 處理

MySQL 5.6.14
下 ALERT 報錯


mysql> ALERT TABLE tPhoto add objI int(4) unsigned not null default 0;
ERROR 1050 (42S01): Table 'mydb/#sql-ib84' already exists

--> 但在 /mysql/data/mydb/ 目錄下 並無 #sql-ib84 相關檔案


解決參考：

• http://grokbase.com/t/mysql/mysql/136kx5qp1w/how-can-i-drop-a-table-that-is-named-logs-sql-ib203-and-appeared-after-mysql-crash
• https://dev.mysql.com/doc/refman/5.6/en/identifier-mapping.html

mysql> create table ttt like tPhoto;
Query OK, 0 rows affected (0.25 sec)

# cp ttt.frm  '#sql-ib84.frm'
# chown mysql:mysql '#sql-ib84.frm'

mysql> DROP TABLE `#mysql50##sql-ib84`;
Query OK, 0 rows affected (0.44 sec)