• Sturgn

    (@sturgn)


    Hi all,
    We had an email from our host saying they had a crash and we somehow now have a corrupted database, Any help would be appreciated, I tried the repair and here are the results;

    The wp_users table is not okay. It is reporting the following error: Table ‘svmistre_wp33.wp_users’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_users table. Error: Table ‘svmistre_wp33.wp_users’ doesn’t exist

    The wp_usermeta table is not okay. It is reporting the following error: Table ‘svmistre_wp33.wp_usermeta’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_usermeta table. Error: Table ‘svmistre_wp33.wp_usermeta’ doesn’t exist

    The wp_posts table is not okay. It is reporting the following error: Table ‘svmistre_wp33.wp_posts’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_posts table. Error: Table ‘svmistre_wp33.wp_posts’ doesn’t exist

    The wp_comments table is okay.

    The wp_links table is not okay. It is reporting the following error: Table ‘svmistre_wp33.wp_links’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_links table. Error: Table ‘svmistre_wp33.wp_links’ doesn’t exist

    The wp_options table is not okay. It is reporting the following error: Table ‘svmistre_wp33.wp_options’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_options table. Error: Table ‘svmistre_wp33.wp_options’ doesn’t exist

    The wp_postmeta table is not okay. It is reporting the following error: Table ‘svmistre_wp33.wp_postmeta’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_postmeta table. Error: Table ‘svmistre_wp33.wp_postmeta’ doesn’t exist

    The wp_terms table is not okay. It is reporting the following error: Table ‘svmistre_wp33.wp_terms’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_terms table. Error: Table ‘svmistre_wp33.wp_terms’ doesn’t exist

    The wp_term_taxonomy table is not okay. It is reporting the following error: Table ‘svmistre_wp33.wp_term_taxonomy’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_term_taxonomy table. Error: Table ‘svmistre_wp33.wp_term_taxonomy’ doesn’t exist

    The wp_term_relationships table is not okay. It is reporting the following error: Table ‘svmistre_wp33.wp_term_relationships’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_term_relationships table. Error: Table ‘svmistre_wp33.wp_term_relationships’ doesn’t exist

    The wp_termmeta table is not okay. It is reporting the following error: Table ‘svmistre_wp33.wp_termmeta’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_termmeta table. Error: Table ‘svmistre_wp33.wp_termmeta’ doesn’t exist

    The wp_commentmeta table is okay.

    Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.

    wp_users: Table ‘svmistre_wp33.wp_users’ doesn’t exist
    wp_usermeta: Table ‘svmistre_wp33.wp_usermeta’ doesn’t exist
    wp_posts: Table ‘svmistre_wp33.wp_posts’ doesn’t exist
    wp_links: Table ‘svmistre_wp33.wp_links’ doesn’t exist
    wp_options: Table ‘svmistre_wp33.wp_options’ doesn’t exist
    wp_postmeta: Table ‘svmistre_wp33.wp_postmeta’ doesn’t exist
    wp_terms: Table ‘svmistre_wp33.wp_terms’ doesn’t exist
    wp_term_taxonomy: Table ‘svmistre_wp33.wp_term_taxonomy’ doesn’t exist
    wp_term_relationships: Table ‘svmistre_wp33.wp_term_relationships’ doesn’t exist
    wp_termmeta: Table ‘svmistre_wp33.wp_termmeta’ doesn’t exist

Viewing 3 replies - 1 through 3 (of 3 total)
  • Mark Ratledge

    (@songdogtech)

    We had an email from our host saying they had a crash and we somehow now have a corrupted database…

    Ask the host to restore a backup of your database and/or your whole site.

    If they don’t have a backup to restore for you, they’re a pretty terrible host.

    In instances like these, you should have your own backups: see https://ww.wp.xz.cn/plugins/search.php?q=backup

    Thread Starter Sturgn

    (@sturgn)

    Thanks for that, we had no backup and the host said they restored our site but that the database was still corrupted.. So I am guessing we have lost our site, well all the stuff is still there just no database to control it I guess…

    Hard lesson to learn about not having your own backups; but that webhost sounds very unreliable, too.

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

The topic ‘Crashed database’ is closed to new replies.