Migrate from Wordpress to Ghost

Setup docker:

#pacman -S docker
#systemctl enable --now docker
#docker run -d --name ghost -p 2368:2368 -v /.../ghost:/var/lib/ghost/content ghost:1-alpine

Setup nginx:

#cat /etc/nginx/nginx/sites-enabled/default
...
location / {
               proxy_set_header   X-Real-IP $remote_addr;
               proxy_set_header   Host      $http_host;
               proxy_pass         http://127.0.0.1:2368;
}
...

Configure ghost for public site:

#docker exec -it ghost /bin/sh
#vi config.production.json

get Wordpress export

upgrade to latest ghost

#docker stop ghost
#docker rm ghost
#docker rmi ghost:1-alpine
#docker run -d --name ghost -p 2368:2368 -v /.../ghost:/var/lib/ghost/content ghost

convert pictures

#cp /.../wp-content/uploads/* /.../ghost/data/content/images
# docker stop ghost
#cp ghost.db ghst.db.bkp
# sqlite3 ghost.db
sqlite> .output changeme.sql
sqlite> .dump
sqlite> .exit
# /.../ghost/data # sed 's|wp-content/uploads|content/images|g' -i changeme.sql                                                                                                                                       :(
# /.../ghost/data # vi changeme.sql
# /.../ghost/data # sqlite3 g.db < changeme.sql

# cp g.db ghost.db
# docker start ghost

resize pics (dosn't work yet)

find . -type f -size +512k -name \*.jpg -print0 | xargs -0 mogrify -size 800