Skip to:
Content
Pages
Categories
Search
Top
Bottom

Re: AARGH! wp_blogs table deleted!


r-a-y
Keymaster

@r-a-y

Damn cat! How many blogs did you have?

If it’s less than, say, 10, it wouldn’t be too much of a hassle to manually recreate the missing table and add back the rows.

Here’s the SQL query to recreate the wp_blogs table. Run this query in your WPMU database.

http://pastebin.com/0gEiQ3ji

After you’ve added the table, click on the wp_blogs table, then click on the “Insert” button to manually add each blog to your wp_blogs table.

For reference, you might want to look at your WPMU database and make note of each blog id and URL.

Skip to toolbar