Retrieve comment from deleted blog post

Posted by tiki16 on January 31, 2013 at 10:19pm

Hi, I had a comment on a blog post that was deleted. I have been requested to retrieve the comment from the deleted blog post. Is there a way it can be done?
thanks

Comments

=-=

Posted by VM on February 1, 2013 at 12:06am

you can check the comment table. However, comments are attached to nodes. It's quite possible the comment was removed when the node was removed.

I guess my only option would

Posted by tiki16 on February 1, 2013 at 3:18pm

I guess my only option would be to take a database backup and import it into my staging site?

=-=

Posted by VM on February 1, 2013 at 3:25pm

that's an option, but not the only one. Another that comes to mind is to open the backup .sql and perform a search on it to locate the text.

That's what I did. Comment

Posted by tiki16 on February 1, 2013 at 3:46pm

That's what I did. Comment wasn't there.
thanks

=-=

Posted by VM on February 1, 2013 at 3:50pm

In future consider unpublishing nodes instead of deleting them to maintain a history.

=-=

Posted by VM on February 1, 2013 at 3:51pm

In future consider unpublishing nodes instead of deleting them to maintain a site history.