Fetching Typo comments

I have moved my blog to my new VPS but I still have to move all the comments which I had on it. I looked around and could not find any plugin/script for doing so I wrote a quick and dirty mysql query to get every thing in a text file (I only have 24 or so comments from my old blog as I got more comments on my blog entries on my facebook page instead. I already sync them manually with the help of this awesome plugin)

So the query is

echo "select contents.title,feedback.email,feedback.author,
feedback.created_at,feedback.body from feedback JOIN contents
ON feedback.article_id=contents.id;"
| mysql -utheuser -pthepassword typo > /tmp/thetextfile.txt;

Mind the username, password and the text file. If you know a better way to import the comments please let me know. I will just copy/paste them one by one from the text file :)

Posted Thursday, April 29th, 2010 under Meta.

Tags: ,

Leave a Reply