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

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

  1. HostStud
    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