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`
echo Making a backup
mkdir bak &> /dev/null
cp db.sql bak/$1.$mydate.sql
echo String replacing latin1 with utf8
cat db.sql | replace CHARSET=latin1 CHARSET=utf8 > db2.sql
echo Pumping back $1 into database
mysql -u root -p $1 < db2.sql
echo Changing db charset to utf8
mysql -u root -p $1 -e "alter database $1 charset=utf8;"
echo $1 Done!
###################################
I hope this can help you ;-)
Sincerely,
Jonathan
Rodrigo Correa a écrit :
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 using the
"Recode", since the message 4200315 FAQ recommends using the procedure
via script.
What is the best option for me to make this conversion? Since my
database is now 14Gb.
Thank´s
------------------------------------------------------------------------
Instale o novo Internet Explorer 8 otimizado para o MSN. Download aqui
<http://ie8.msn.com/microsoft/internet-explorer-8/pt-br/ie8.aspx>
------------------------------------------------------------------------
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
