Working with MySQL 5.7 and after a power outage everything seems ok. Then I must rename a table. So, easy-peasy:
RENAME TABLE MYTABLE TO MY_REAL_TABLE
>Table MY_REAL_TABLE already exists.
So I try to drop the mentioned table:
DROP TABLE MY_REAL_TABLE
>Table MY_REAL_TABLE does not exists.
Why??????
All commands are on same CLI so, no confusion about server is possible. I'm using same database for both commands. Checked if data directory contained table files. Non existent.
The information_schema.tables has no row for MY_REAL_TABLE.
I am stuck as I can do nothing regarded to this table and I need it renamed.