Repairing database
-
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 existI 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!
- The topic ‘Repairing database’ is closed to new replies.