Convert all WordPress tables to UTF8MB4 with WP-CLI

wpcli-db-charset.sh

#!/usr/bin/env bash
# Author Amaury Balmer - BEAPI.fr
# See: https://wordpress.stackexchange.com/questions/195046/relaunch-4-2-utf8mb4-databse-upgrade/244992#244992
# Purpose - Convert all tables to UTF8MB4 with WP-CLI

# Create array of all tables
WPTABLES=($(wp db tables --all-tables))

# loop through array and alter tables
for WPTABLE in ${WPTABLES[@]}
do
    echo "Converting ${WPTABLE} to UTF8MB4"
    wp eval "echo maybe_convert_table_to_utf8mb4( ${WPTABLE} );" --allow-root
    echo "Converted ${WPTABLE} to UTF8MB4"
done