Some database problems could not be repaired

  • Bunty

    (@bhargavbhandari90)


    9 years, 10 months ago

    here is the error:

    wp_usermeta: Table is marked as crashed and last repair failed
    wp_posts: Table is marked as crashed and last repair failed
    wp_options: Table is marked as crashed and last repair failed
    wp_postmeta: Table is marked as crashed and last repair failed
    wp_term_taxonomy: Table is marked as crashed and last repair failed

Viewing 7 replies - 1 through 7 (of 7 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    9 years, 10 months ago

    Are you using shared hosting or are you hosting on a VPS?

    Do you have backukps of your site from before this happened?

    cristianrendina

    (@cristianrendina)

    9 years, 10 months ago

    Same issue.
    I’m using a VPS.
    I backed up my lib/mysql folder before, but when I try to restore it nothing seems to work properly.
    I backed-up my worpress folder as well.
    Actually I’m building a new site and I could probably backup my previous wordpress installation if it could work, but the problem is that I have no clue why the issue happened and I’m afraid I will encounter the same problem in few days.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    9 years, 10 months ago

    VPS is good. 🙂

    1. Login via SSH

    2. Stop apache/httpd

    3. type “mysqlcheck -u root -p –auto-repair datbasename

    The tables got corrupted because, for some reason, your mysql server crashed. Look at the mysql logs as well as /var/log/messages.

    Thread Starter Bunty

    (@bhargavbhandari90)

    9 years, 10 months ago

    Or you can try to install database on localhost and try to repair from local. And see what happens.

    cristianrendina

    (@cristianrendina)

    9 years, 10 months ago

    Hi Steve,
    I did what you suggested me and I can access to my wp-admin page and to my site, but everything is super slow, therefore I checked the site speed with Google pagespeed insignt and a timeout message is returned. I had this issue already in the past and it was somehow due to something in my tables.
    I just noted that some tables in phpmyadmin have a “overhead”. I have no clue why and how to fix it.
    I will try to contact the support of the pluging I’m using.

    Thanks,
    Cristian

    P.S.
    I could not find the folder /var/log/messages. I found instead the folder /var/log/mysql in which I had error logs.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    9 years, 10 months ago

    “overhead” just means you have empty space in your tables; it can be recovered using a plugin like wp-sweep or wp-optimize.

    A lot of your issues may just be poor tuning of your VPS.

    Christian: IN the future, please do not jump in on threads with “I have the same problem”. You may, you may not. But at least I get confused as to who I’m trying to help. It’s better to keep things on their own tracks. Thanks.

    Thread Starter Bunty

    (@bhargavbhandari90)

    9 years, 10 months ago

    Hi cristianrendina,

    if you have access of phpmyadmin, then you can optimize your tables and repair it. This will resolve your problem.

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Some database problems could not be repaired’ is closed to new replies.