#!/bin/bash
DATABASE = "hlstatsx"
MYSQL="mysql -uroot -p****** -N --database=$DATABASE"
#convert database with all tables to utf8mb4
echo "ALTER database $DATABASE CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin;" | $MYSQL

echo 'show tables' | eval $MYSQL | while read table
do
    echo "ALTER TABLE $table ROW_FORMAT=DYNAMIC;" |
        eval $MYSQL
    echo "ALTER TABLE $table CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;" |
        eval $MYSQL;