Update MySQL Database charset/collate (and all tables)

mysql_update_database_charset.sh

#!/bin/bash

# cf. https://lxadm.com/MySQL:_changing_database_character_set_and_collate
# cf. https://medium.com/@alexBerg/my-war-with-mysql-or-how-did-i-switch-to-full-utf8mb4-73b257083ac8
# Assume MySQL authentication done via .my.cnf

DATABASE="db_name"

#CHARACTER_SET=utf8
#COLLATE=utf8_unicode_ci
CHARACTER_SET=utf8mb4
COLLATE=utf8mb4_unicode_ci

echo "ALTER DATABASE $DATABASE CHARACTER SET $CHARACTER_SET COLLATE $COLLATE;"
echo "ALTER DATABASE $DATABASE CHARACTER SET $CHARACTER_SET COLLATE $COLLATE;" | mysql

TABLES=$(echo SHOW TABLES | mysql -s "$DATABASE")

for TABLE in $TABLES ; do
    echo "ALTER TABLE $TABLE CONVERT TO CHARACTER SET $CHARACTER_SET COLLATE $COLLATE;"
    echo "ALTER TABLE $TABLE CONVERT TO CHARACTER SET $CHARACTER_SET COLLATE $COLLATE;" | mysql "$DATABASE"
    echo "ALTER TABLE $TABLE DEFAULT CHARSET=$CHARACTER_SET COLLATE $COLLATE;"
    echo "ALTER TABLE $TABLE DEFAULT CHARSET=$CHARACTER_SET COLLATE $COLLATE;" | mysql "$DATABASE"
don