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