Announcement

Collapse
No announcement yet.

Post Table Crashed ?!

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    Leave a comment:


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

    Leave a comment:


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

    Leave a comment:


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

    Leave a comment:


  • jasonlitka
    replied
    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"

    Leave a comment:


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

    Leave a comment:


  • jasonlitka
    replied
    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.

    Leave a comment:


  • krg2k
    replied
    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

    Leave a comment:


  • Lynne
    replied
    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.

    Leave a comment:


  • krg2k
    started a topic Post Table Crashed ?!

    Post Table Crashed ?!

    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X