WordPress.org

Ready to get started?Download WordPress

Forums

Restoring backup error (1 post)

  1. Dazed
    Member
    Posted 1 year ago #

    Hi guys

    The site in question is pink-puppies.com

    We noticed there was a WordPress update so we backed the website up (as you do) before upgrading it. After doing so, we made a few changes to the site but wanted to go back to a previous version of the page so we restored from the prior backup.

    After doing that we got an error "One or more database tables are unavailable. The database may need to be repaired."

    I have checked the wp-config file and we have not made any user/password changes so all appears to be in perfect order.

    If we try to acces http://pink-puppies.com/wp-admin/ we get the error "One or more database tables are unavailable. The database may need to be repaired."

    I have a backup .sql file which I am trying to restore in phpmyadmin but get this error

    SQL query:

    CREATE TABLE wp_commentmeta (

    meta_id BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
    comment_id BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0',
    meta_key VARCHAR( 255 ) DEFAULT NULL ,
    meta_value LONGTEXT,
    PRIMARY KEY ( meta_id ) ,
    KEY comment_id ( comment_id ) ,
    KEY meta_key ( meta_key )
    ) ENGINE = INNODB AUTO_INCREMENT =134 DEFAULT CHARSET = latin1;

    MySQL said:

    #1050 - Table 'wp_commentmeta' already exists

    Any ideas? This is also the error/repair log

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

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

    The wp_posts table is not okay. It is reporting the following error: Table 'pinkpupp_wrdp1.wp_posts' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_posts table. Error: Table 'pinkpupp_wrdp1.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 'pinkpupp_wrdp1.wp_links' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_links table. Error: Table 'pinkpupp_wrdp1.wp_links' doesn't exist

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

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

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

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

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

    The wp_commentmeta table is okay.

    Thank you!!

Topic Closed

This topic has been closed to new replies.

About this Topic