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

  8. hilmy
    September 25th, 2010 at 09:17 | #8
    Reply | Quote

    Thx, It’s working

  9. Sleek
    October 26th, 2010 at 13:54 | #9
    Reply | Quote

    Thanks

  10. E P S I L O N
    April 18th, 2011 at 07:01 | #10
    Reply | Quote

    Thanks you very very very much . :* :D

  11. kitchen
    April 8th, 2012 at 09:34 | #11
    Reply | Quote

    HI
    Wow! what an idea ! What a concept ! Beautiful nice and useful!.. Amazing …
    thank you!

  12. Black Bedroom
    May 28th, 2012 at 12:33 | #12
    Reply | Quote

    Hey,
    Fine points are available all around, many thanks. I anticipate reading even more.

  13. PDFGood
    June 18th, 2012 at 21:13 | #13
    Reply | Quote

    Before, i used myisamchk -o -f tables.MYI and very slow and still got error…
    Thanks dude, You save my day…

  14. moshhud ahmed
    September 14th, 2012 at 23:54 | #14
    Reply | Quote

    thanks a lot. it’s working perfectly.

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