Clever Geek Handbook

Mysql Safe to delete .TMD file?

Shortly speaking. I had a very large corrupt InnoDB table. Tried several things to rebuild / repair the table. (I was finally successful). However, one of the things I tried was to create a new table with Myisam engine forced to start innodb, however there was another failure along the way and I was left with a .TMD file for that table.

Just wondering if I can delete this file? The table is not showing anywhere in the database, via show tables, drop table does nothing. etc. At this point, it just takes up disk space in my data directory.

+3


source to share


1 answer


The .TMD file is an intermediate data file for the table that is to recreate the data file.



So, you can delete it because it is usually used as a temporary file, but you can rename the file and check what happens just in case.

+4


source






More articles:


All Articles