#!/bin/bash

echo "Run in mysql console:"

dbname=$1

mysql -u root -p ${dbname} -B -N -e "SHOW TABLES" | awk '{print "SET foreign_key_checks = 0; ALTER TABLE", $1, "CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; SET foreign_key_checks = 1; "}'
echo "ALTER DATABASE ${dbname} CHARACTER SET utf8 COLLATE utf8_general_ci;"