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

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

April 6th, 2009 Leave a comment Go to comments

Hello,

If you are getting Can’t create new tempfile: ‘tablesname.TMD file error while repairing corrupted database tables please try use following command to fix it

Solution.

# myisamchk -r -f  tables.MYI

Regard’s

Stacy.

Categories: MySQL Tags: ,
  1. a
    October 6th, 2007 at 07:38 | #1
    Reply | Quote

    great Stacy! and remember to umount /tmp

  2. Greg
    June 24th, 2008 at 21:16 | #2
    Reply | Quote

    Woo-hoo! Thanks very much!!

  3. ahmed
    September 13th, 2008 at 06:46 | #3
    Reply | Quote

    very nice !!! am searching since a day ..for solution

    tnx alot

  4. Veeramani
    October 4th, 2008 at 02:51 | #4
    Reply | Quote

    Cool Man…

    Presently data is recovering. I hope this will fix :)

    Once again Thanks:)

  5. Verynice
    December 4th, 2008 at 05:43 | #5
    Reply | Quote

    You save my life!! thank you very much

  6. Nice:)
    July 14th, 2009 at 10:57 | #6
    Reply | Quote

    Thank you very much Stacy :)

  7. endrozz
    July 27th, 2010 at 12:53 | #7
    Reply | Quote

    great jobs boss

    thx u for share

  1. April 2nd, 2010 at 19:12 | #1
    cdonts