Re: [otrs] Conversion of a Latin1 (ISO-8859-1) DB to UTF-8 for use with OTRS - MySQL (14 Gb)

2009-07-28 Thread Jonathan Peyrot
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`

[otrs] Conversion of a Latin1 (ISO-8859-1) DB to UTF-8 for use with OTRS - MySQL (14 Gb)

2009-07-27 Thread Rodrigo Correa
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