MySQL charset converting script [latin1 to utf8]

#!/bin/bash


# 
#             CHANGE IT!!!!
# NO SPACE BETWEEN "-p" AND PASSWORD.
DB=your_database_name
USER=" -u _username_"
PASS=" -p_password_"
DBHOST=" -h _host_"

for i in `echo "show tables" | mysql $DB $USER $PASS $DBHOST`
do
if [ $i != 'Tables_in_'$DB ]; then
echo "ALTER TABLE "$i" CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;" | mysql $DB $USER $PASS $DBHOST
sleep 2
fi
done
 

Based on:
http://dev.mysql.com/doc/refman/5.0/en/charset-column.html

Useful too:
http://www.mysqlperformanceblog.com/2009/03/17/converting-character-sets/

-- vladget