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

If you are getting error like Can’t create new tempfile: ‘tablesname.TMD file error while repairing corrupted database tables please try use following command to fix it.
Solution : 
You need to just run below command on the shell.
# myisamchk -r -f  tables.MYI
Thats all.