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

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 is

myisamchk -r -f tables.MYI

Tagged . Bookmark the permalink.

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

  1. I love your blog.. very nice colors & theme. Did you create this website yourself or did you hire someone to do it for you? Plz reply back as I’m looking to create my own blog and would like to know wheere u got this from. thanks

  2. adm!n says:

    I have changed the theme now 🙂

  3. Most of the times i visit a blog I notice that most blogs are amateurish. On the contrary,I could honestly say that you writting is decent and your website solid.

  4. Very nice website design you have. Did you do it yourself?

  5. Excellent read . I just wanna tell u “Thanks”

  6. Mandy Waskow says:

    I have developed a blog and and i want to change the theme.Yours looks pretty decent! You could visit my website and tell me your opinion!

  7. I am so grateful for your blog.Much thanks again.

  8. shazeeii says:

    i was really struggling to repair crashed table and it had about one million post , your command really solved my issue . thank you very much

  9. Morgan says:

    Where shall i be when running this command? Wich folder?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.