Any way to restore hastily deleted comments?

Bastards put my own URL in one of their spam comments and in my haste I deleted some legitimate comments (posted by myself). Feelin’s stupid.
If I go to backups of my mysql database should I be able to resurrect the killed comments?
I did manage to preserve the post IDs for the comments, which should help in plundering any backup of the database:
2222
2560
1333
2510
361
249
244
225
217
206
105
101


Posted

in

by

Tags:

Comments

3 responses to “Any way to restore hastily deleted comments?”

  1. jima Avatar

    Yes, you can. Export the recordset that you get from this command, run on the backed-up DB:
    SELECT * FROM mt_comment WHERE comment_entry_id
    IN (2222,2560,1333,2510,361,249,244,225,217,206,105,101)
    and then import the records into your current MT DB, and just do a rebuild.
    Note that this assumes that you just have one MT blog in your current DB. If not, then you may have to include the blog_id in your SQL statement. Quick way to figure that out:
    1) Go to your MT main menu, and mouse over the link for the blog you’re working with. Note the number after “blog_id=” in the URL in your status line.
    2) Revise the SQL statement to look like this:
    SELECT * FROM mt_comment WHERE comment_blog_id = blog ID here AND comment_entry_id
    IN (2222,2560,1333,2510,361,249,244,225,217,206,105,101)
    Hope that helps.

  2. Tim Avatar

    Or for those of us who are technically challenged, we can use GUI programs like MySQL-Front or SQLyog (sorry , both are Windows, don’t know the Mac equivalents) to poke around the backups.

  3. igor Avatar
    igor

    Ihre Krankenkassenbeitr