Cleaning up spam and deleted blog by mistake

I was cleaning up spam and deleted my blog by mistake.  Anyway I can retrieve my blog?

Do you have the sql back up with that blog entry in it? I would also be interested in how to manually insert it back into database as this could happen to me as well! 

We have done that.  You will need a backup that contains your blog; you may lose some recent entries.  You also have to reclaim the comments as well.

Let me get the SQL you will need; might be later today, and I will post back.

Note: getting the blog back with entries was the easier part.  Figuring out the query to run to get the blog comments back was a bit more involved.

Here are the steps that you need to do.

1)
Export all the records from the backup database from the bx_blogs_posts table with OwnerID XX; where XX is going to be your ID number.

Import the records into your database

Comments:

2)  Export from the backup database using the following:
SELECT `bx_blogs_cmts`.*
FROM  bx_blogs_cmts, bx_blogs_posts
WHERE ((`bx_blogs_posts`.`OwnerID` = "XX") AND (`bx_blogs_cmts`.`cmt_object_id`  = `bx_blogs_posts`.`PostID` ))

again you replace XX with your user ID

And import those into the comments table

What you can do is to create a new database; then import from the site backup into this database.  Then you can just use your database tool; phpMyAdmin, or what have you, to make it easier to export the records from the backup database.

Thank you for this.  I will try it out.

Useful info! Thanks!