• Resolved Andrea

    (@canadianfoodiegirl)


    Help, I broke one of my websites.
    It was a multisite network (2 sites/Databases) and I wanted to delete the second site, which was a staging site. I moved the staging site to trash from the network dashboard, then deleted the lines related to multisite on wp-config according to instructions I found.

    Now the staging site is the only one that remains. It’s as if I did something backwards and accidentally deleted the wrong site, but I specifically moved the one called “staging” to the trash from the Network Dashboard. Evidently, when I deleted the multisite network the wrong site got deleted, though I don’t understand why the subdomain “/staging1” and “staging1/wp-admin” would remain but not the root directory.

    Error at the website:

    Error establishing a database connection

    Error at /wp-admin:

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

    I clicked to repair it and the subsequent screen, somewhat helpful, says “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.”

    Here’s the list of errors (I’ve replaced the actual database name with “[db]”):

    wp_1_posts: Table ‘[db].wp_1_posts’ doesn’t exist
    wp_1_comments: Table ‘[db].wp_1_comments’ doesn’t exist
    wp_1_links: Table ‘[db].wp_1_links’ doesn’t exist
    wp_1_options: Table ‘[db].wp_1_options’ doesn’t exist
    wp_1_postmeta: Table ‘[db].wp_1_postmeta’ doesn’t exist
    wp_1_terms: Table ‘[db].wp_1_terms’ doesn’t exist
    wp_1_term_taxonomy: Table ‘[db].wp_1_term_taxonomy’ doesn’t exist
    wp_1_term_relationships: Table ‘[db].wp_1_term_relationships’ doesn’t exist
    wp_1_commentmeta: Table ‘[db].wp_1_commentmeta’ doesn’t exist

    I did export a backup xml file before embarking on this but when I opened it the content appeared old.

    This must be an easy fix once I know how to do it.

    It would be great to get this back up ASAP. Thanks!

Viewing 1 replies (of 1 total)
  • Thread Starter Andrea

    (@canadianfoodiegirl)

    Resolved. I re-added the multi-site network. It made a back up copy of my website come to life.

Viewing 1 replies (of 1 total)
  • The topic ‘Repairing database’ is closed to new replies.