I have just migrated my Wordpress blog over to Ghost, and it’s running. Phew, that was quite a lot of work!
However, I still need to migrate the excerpts from Wordpress so that the search results in Google will look good.
Under Wordpress, I used the Yoast SEO plugin. I opened the MySQL database used by Wordpress and found the post excerpts using this SQL statement:
select post_id as id, wp_posts.post_name as slug, meta_value as excerpt from wp_postmeta left join wp_posts on wp_postmeta.post_id = wp_posts.id where wp_postmeta.meta_key = '_yoast_wpseo_metadesc';
Looks like a nice table.
How can I import this into Ghost? Is there a nice hack for this?