Migrate a WordPress multisite from http to https using wp-cli

wp-http-to-https.sh

#!/bin/sh

set -e
set -x

_prog_name="${0##*/}"
LOGFILE="/tmp/${_prog_name}.log"

# XXX change wp_root to match the root of your multisite wordpress installation
wp_root='/var/www/wordpress-multisite-root-directory/'
alias wp="wp --path=${wp_root}"

log() {
	msg="$*"
	datetime="$(date --utc --iso-8601='ns')"
	printf -- ':: %s %s\n' "$datetime" "$msg"
}

convert_blog() {
	blog_id="$1"
	url="$2"

	domain="${url#*:}"
	domain="${domain#//}"
	domain="${domain%/}"

	wp search-replace \
		--url="${domain}" \
		"http://${domain}" "https://${domain}" \
		"wp_${blog_id}_*" \
		--recurse-objects \
		--skip-columns=guid \
		--network
}

convert_blogs() {
	wp site list --fields=blog_id,url --format=table \
		| while read -r blog_id url _
		do
			log "start processing blog $blog_id $url"
			if test "$blog_id" -gt 0
			then convert_blog "$blog_id" "$url"
			else log "skipping blog $blog_id $url"
			fi
			log "end processing blog $blog_id $url"
		done
}

run() {
	log 'start process'
	convert_blogs
	log 'end process'
}

run 2>&1 | tee -a "${LOGFILE}"