#1932 table 'tablename' doesn't exist in engine

Question

I have this problem with an table. i want to delete it and does not work

I tried to delete de .ibd file, them rename some frm file to the same name as te ibd to drop the table , does not work

when i drop table, and then create it again, it gives me this error #1813 table space for table name still exist, please discart tablespace before import. and if i try ti discard, says that nametable does not exist

I even tried to alter the table

I`m using xampp

does anyone knwo how to fix this?

Don't delete files. Don't rename files. Log into your server and delete the tables properly. `DELETE TABLE yourtablename;` There's almost never a good reason to monkey around in the file system with a database unless something is corrupt. — JNevill, May 13 '19 at 16:41

FranklinA · Answer 1 · 2019-08-01T18:03:13.317

0

In my case, I solve this with: DROP TABLE IF EXISTS yourtablename, yourtablename, yourtablename; and reload the db backup.

I use XAMPP in Osx,You can also see logs: tail /Applications/XAMPP/xamppfiles/var/mysql/yourFile.local.err

You can also remove .ibd, I use XAMPP:

You should now work with your backup.

edited Aug 01 '19 at 18:03

answered Aug 01 '19 at 14:38

FranklinA

2,151
1
8
5

#1932 table 'tablename' doesn't exist in engine

1 Answers1

Linked