Restore Old Wordpress Posts to Octopress

mysql-import-wordpress-to-octopress.rb

# gem install mysql2
# import mysqldump to database
# fix database name

require 'mysql2'
client = Mysql2::Client.new(:host => "localhost", :username => "root", database: "wp")
results = client.query(%Q{select post_modified, POST_NAME, POST_TITLE, post_content from wordpress_posts})
results.entries.each do |e|
  file_to_touch = e["post_modified"].to_s.split(" ")[0] + "-"+ e["POST_NAME"]+".html"

data = %Q{
---
layout: post
title: #{e["POST_TITLE"]}
date: #{e["post_modified"]}
comments: false
categories:
---

#{e["post_content"]}
}

t = open(file_to_touch,"w+")
t.write(data)
t.close

end