Proper Way to Remove Mysql Tables

by chris85   Last Updated April 16, 2018 02:06 AM

I was going to ask why mysqldump was trying to write dropped tables but I found that answer from this question, How do you remove reported non existing tables from mysql?.

Removing the .frm files from my datadir has resolved the mysqldump issue of trying to dump non-existent tables. Now my question is how do I drop a table and have all references to it removed? I would have thought issuing the drop table would remove all associated files in the directory. I am using MyISAM so perhaps the issue is related to that.

Related Questions

Fixing MyISAM database without losing data

Updated May 28, 2015 22:02 PM

How to check foreign keys related to a table

Updated May 24, 2015 21:02 PM

Speedup DROP huge MySQL replicated table

Updated May 03, 2017 11:06 AM

Replacing table with another

Updated April 04, 2017 19:06 PM