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

If you are getting following MySQL Error :

Can’t create new tempfile: ‘tablesname.TMD
mysql can't create new tempfile on some tables..

File error while repairing corrupted database tables.
You can use following command to fix it

# myisamchk -r -f YourTable.MYI