Jump to content
×
×
  • Create New...
  • 0

Account crash


dripone

Question

Hey guys!

I tried to repair my account table, but it keeps saying that it's marked as crashed.

 

Can't create new tempfile: './account/account.TMD'

Last time I used a query to fix the item table, but I lost that query somewhere.
Can someone tell me what to do now?

Link to comment
Share on other sites

  • Answers 1
  • Created
  • Last Reply

Top Posters For This Question

Popular Days

Top Posters For This Question

1 answer to this question

Recommended Posts

  • 0

What did you do? 
You should run myisamchk on the .MYD file.

https://dev.mysql.com/doc/refman/5.0/en/myisamchk.html

If this is not working you can removing old tempfiles like this (dont know the path on FreeBSD but just check where to find mysql - this is an Debian Linux example):

rm /var/lib/mysql/*/*.TMD

Im sure that this is a permission problem in group. You are trying this with navicat, or?

Edited by Ayaka
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.