June 9, 2004
Christian Crumlish
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 by xian at June 9, 2004 9:21 AM
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.
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.
Other incoming links (via Technorati)
Hosted by Mediajunkie.
