DB error

  • I am not professional to fix this

    any one can help .. please ,,

    wp_users: 1 client is using or hasn’t closed the table properly
    wp_usermeta: 60 clients are using or haven’t closed the table properly
    wp_posts: 105 clients are using or haven’t closed the table properly
    wp_options: Table is marked as crashed
    wp_postmeta: 180 clients are using or haven’t closed the table properly
    wp_terms: 54 clients are using or haven’t closed the table properly
    wp_term_taxonomy: 69 clients are using or haven’t closed the table properly
    wp_term_relationships: 79 clients are using or haven’t closed the table properly

    hope any one to help.
    thank you

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

  • Hi, alsadr, I would suggest taking a look at this post on StackOverflow (you have a problem with your wp_options table): https://stackoverflow.com/a/25757835/4372244

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Repair your database via PHPMYADMIN: https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimizing-and-repairing-mysql-databases-with-phpmyadmin

    Thread Starter alsadr

    (@alsadr)

    I did all what is there .. but it is missing table .. so ..

    for the corrupted DB
    1- will get copy of old DB
    2- recreat new site with the same details .. blank one and reinstall the same blugins as frish copy
    now we have new site without any article.
    then I will install the old DB (I copied before ) to new DB.
    3- mintion the origenal site folder on the site to the new DB so all config or theme and any other things will be there .. and even plugins will get the new setting from new DB.

    this way ,, will succeed or if I copy the old DB will delete the new one ? it will marge or or replacement?

    thank you

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    If you’re importing via PHPMYADMIN, the usual operation is to drop and recreate the table from the new data, so it’s a replacement, not a merge.

    Thread Starter alsadr

    (@alsadr)

    so .. let me clear it .. the old DB is A the new is B
    if some table is deleted or missing from A . and I will install A to B … will the new DB A+B complete or it will be effected ?
    will be will get the missing table from A as A is new and complete .. ( I mean complete in plugin and so on)

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    When you import your new database, any tables OF EXACTLY THE SAME NAME will replace tables already in the database.

    Thread Starter alsadr

    (@alsadr)

    ok … sorry for long explanation ,,,
    I will create new data base as the old one.. then will install the old one over the new one
    the old one will replace the new one and keep the table witch missing in the old one .
    at the same time any more tables on the old one will be as it is

    is that correct .. ?

    I am sorry .. cause I am not professional. and I will do it with risk.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘DB error’ is closed to new replies.

Tags