As I said before, get your host to see if they can restore a backup. YES, you can re-create them… but it’s by reinstalling WP. And I suspect you don’t want to.
I think I might be having the same problem. My whole site was hosed recently so I thought “no problem, restore from backup!” but when I import my database backup. WordPress complains that multiple tables don’t exist.
Since this was a WordPress MU site originally, the tables are named like “wp_92_options” for site 92 so there isn’t a “wp_options” table, or something happened to the backup so that I don’t have the original tables.
Here are the errors:
wp_posts: Table ‘fllcwp.wp_posts’ doesn’t exist
wp_comments: Table ‘fllcwp.wp_comments’ doesn’t exist
wp_links: Table ‘fllcwp.wp_links’ doesn’t exist
wp_options: Table ‘fllcwp.wp_options’ doesn’t exist
wp_postmeta: Table ‘fllcwp.wp_postmeta’ doesn’t exist
wp_terms: Table ‘fllcwp.wp_terms’ doesn’t exist
wp_term_taxonomy: Table ‘fllcwp.wp_term_taxonomy’ doesn’t exist
wp_term_relationships: Table ‘fllcwp.wp_term_relationships’ doesn’t exist
wp_commentmeta: Table ‘fllcwp.wp_commentmeta’ doesn’t exist
Is this a problem going from WordressMU to WordPress?
Since this was a WordPress MU site originally, the tables are named like “wp_92_options” for site 92
that’s exactly the same in a multsite install. EXACLTY.
The one difference is what is shown in your errors:
wp_comments’ doesn’t exist
because in a mu install, it was wp_1_comments. THAT is the difference.
Don’t put the multisite stuff in the config file. Use the old mu config file.