backup DB and restore to UAT failed

  • I’m trying to backup my wordpress from production and restore it to UAT…

    using mysqldump …i have tried the same before, it is working fine…

    but i’m not able to do the same right now….

    for my website showing

    Error establishing a database connection

    then i login to my admin panel which is wp-login.php

    One or more database tables are unavailable. The database may need to be repaired.

    The wp_users table is okay.

    The wp_usermeta table is not okay. It is reporting the following error: InnoDB: Tablespace is missing for table wp3/wp_usermeta.. WordPress will attempt to repair this table…
    Failed to repair the wp_usermeta table. Error: InnoDB: Tablespace is missing for table wp3/wp_usermeta.

    The wp_posts table is not okay. It is reporting the following error: InnoDB: Tablespace is missing for table wp3/wp_posts.. WordPress will attempt to repair this table…
    Failed to repair the wp_posts table. Error: InnoDB: Tablespace is missing for table wp3/wp_posts.

    The wp_comments table is not okay. It is reporting the following error: InnoDB: Tablespace is missing for table wp3/wp_comments.. WordPress will attempt to repair this table…
    Failed to repair the wp_comments table. Error: InnoDB: Tablespace is missing for table wp3/wp_comments.

    The wp_links table is not okay. It is reporting the following error: InnoDB: Tablespace is missing for table wp3/wp_links.. WordPress will attempt to repair this table…
    Failed to repair the wp_links table. Error: InnoDB: Tablespace is missing for table wp3/wp_links.

    The wp_options table is not okay. It is reporting the following error: InnoDB: Tablespace is missing for table wp3/wp_options.. WordPress will attempt to repair this table…
    Failed to repair the wp_options table. Error: InnoDB: Tablespace is missing for table wp3/wp_options.

    The wp_postmeta table is not okay. It is reporting the following error: InnoDB: Tablespace is missing for table wp3/wp_postmeta.. WordPress will attempt to repair this table…
    Failed to repair the wp_postmeta table. Error: InnoDB: Tablespace is missing for table wp3/wp_postmeta.

    The wp_terms table is not okay. It is reporting the following error: InnoDB: Tablespace is missing for table wp3/wp_terms.. WordPress will attempt to repair this table…
    Failed to repair the wp_terms table. Error: InnoDB: Tablespace is missing for table wp3/wp_terms.

    The wp_term_taxonomy table is not okay. It is reporting the following error: InnoDB: Tablespace is missing for table wp3/wp_term_taxonomy.. WordPress will attempt to repair this table…
    Failed to repair the wp_term_taxonomy table. Error: InnoDB: Tablespace is missing for table wp3/wp_term_taxonomy.

    The wp_term_relationships table is not okay. It is reporting the following error: InnoDB: Tablespace is missing for table wp3/wp_term_relationships.. WordPress will attempt to repair this table…
    Failed to repair the wp_term_relationships table. Error: InnoDB: Tablespace is missing for table wp3/wp_term_relationships.

    The wp_termmeta table is not okay. It is reporting the following error: InnoDB: Tablespace is missing for table wp3/wp_termmeta.. WordPress will attempt to repair this table…
    Failed to repair the wp_termmeta table. Error: InnoDB: Tablespace is missing for table wp3/wp_termmeta.

    The wp_commentmeta table is not okay. It is reporting the following error: InnoDB: Tablespace is missing for table wp3/wp_commentmeta.. WordPress will attempt to repair this table…
    Failed to repair the wp_commentmeta table. Error: InnoDB: Tablespace is missing for table wp3/wp_commentmeta.

    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.

    may i ask how to fix it ?

    please help.

Viewing 1 replies (of 1 total)

  • I’m not sure how you could have Error establishing a database connection from the front-end but a successful login from the back-end + then throwing errors.

    The idea would be to either not be able to contact the database from either side or get errors from both as well.

    That being said maybe there was something wrong going on during the export/import and resulted to a corrupt database. I’d recommend a new clean export ( check that the original database is ok first ) -> import, a re-start of the mysqld so it can read all the databases from scratch and fresh & double check the wp-config.php to point on the correct host / database.

    Since it hasn’t happened to me yet (the half-working half-not part) to be able to give more thorough insights a good read might be https://forums.cpanel.net/threads/innodb-corruption-repair-guide.418722/ to at least identify what is causing the issue here.

Viewing 1 replies (of 1 total)
  • The topic ‘backup DB and restore to UAT failed’ is closed to new replies.