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/