Long story short. I had a very large corrupt InnoDB table. Tried a number of things to rebuild/recover the table. (I was finally successful) However, one of the things I tried was building a new table with Myisam engine with force innodb reovery on, however there was another crash along the way and I'm left with a .TMD file for that table.
Just curious if I'm safe to delete this file? Table does not show up anywhere in the database, via show tables, drop table doesn't do anything. etc. At this point its just taking up disk space in my data directory.
Some common causes of corrupted tables are: The MySQL server stops in middle of a write. An external program modifies a table that's simultaneously being modified by the server. The machine is shut down unexpectedly.
The .TMD file is an intermediate data file for a table that needs to recreate its data file.
So you can remove it because it's normally used as a temporarly file but you could rename the file and check what happens just in case.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With