Hi Rodrigo,
I had the same problem and I used this script in bash :
###
#!/bin/bash
echo Script to convert MySQL latin1 charsets to utf8.
echo Usage: $0 dbname
echo Dumping out $1 database
mysqldump -u root -p --add-drop-table $1 > db.sql
mydate=`date +%y%m%d`
Hi,
I have the need to convert the collation of a database in Mysql (14Gb).
My database is using collation latin1 (ISO-8859-1), I need to convert it to
UTF-8.
I found the forum two ways of doing this, (FAQ: 4200202 and 4200315). The
message recommends FAQ 4200202 perform the procedure usin