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
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
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
Tags: comments, Typo