Got the following error while trying to repair a crashed DB:
Mysql error : Can’t create new tempfile: *.TMD file
You need to run the myisamchk command on the table in question instead of the whole database.
Issue the following by hopping into the directory of the database at /var/lib/mysql/DB/ and issue the following:
myisamchk -r -f TABLE-NAME.MYI
It’ll take time depending on the size of the database.