Mysql error : Can’t create new tempfile: *.TMD file

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.