Post Table Crashed ?!

[krg2k]

few days ago the POST table of our forum crashed for no reason that we know of, so the forum is up and running except when we click on any of the forum sections like "general discussion" etc we get a database error saying:

MySQL Error : Table 'post' is marked as crashed and last (automatic?) repair failed

any help would be greatly appreciate it in fixing out database..

Thanks

[Lynne]

Go to the Maintenance section of your Admin CP and then Repair/Optimize Tables. Select the post table and then select Repair. You may have to run it a couple of times. You may want to also Optimize it.

[krg2k]

hello
I've done that many times it keeps giving me errors on that process saying the post count is 234234 and should be 0 !, and it also says that it has crashed and can't be repaird etc..

and everytime we run the replair script in the adminCP our /tmp folder in the linux machine gets maxed out:

/tmp 1012M 961M 0 100% /var/tmp

[jasonlitka]

The volume holding your temp folder for MySQL (/tmp by default) needs to be at least 3x the size of the size of the broken table in order for the repair to succeed.

If your /tmp partition is not large enough then you should temporarily move your MySQL temp folder to another volume so the repair can be completed.

[krg2k]

thanks for the hint. how do you change the temp folder of mysql on linux fedora core

[jasonlitka]

The following assumes that your / partition has enough free space. If it doesn't, change the path I specified to something else.

1. Log into your server as 'root' (directly, su, or sudo, it doesn't matter)
2. Run "mkdir /mysqltemp"
3. Edit your /etc/my.cnf file and add "tmpdir = /mysqltemp"
4. Run "service mysqld restart"
5. Run your table repair
6. Edit your /etc/my.cnf file and remove the "tmpdir" line
7. Run "service mysqld restart"
   

[krg2k]

did that and still writes to the /var/tmp folder ?!!

[jasonlitka]

Was there already a "tmpdir" line in your my.cnf? Did you restart mysqld after making the change?

[krg2k]

no there was no tmpdir line
and yes I did restart the mysql service

[krg2k]

thanks guys
got it fixed.. by changing the tmp folder and repairing the db :PPPPp