I've break line misteak in my previous message, this is the fix : $ mysqldump --user=root --password=password --host=mybox mydatabase -- default-character-set=latin1 > mydatabase.latin1.sql$ mysqldump -- user=root --password=password --host=mybox mydatabase --default-character- set=latin1 > mydatabase.latin1.sql
$ sed -e 's/latin1/utf8/g' mydatabase.latin1.sql > mydatabase.utf8.sql $ iconv -f latin1 -t utf8 mydatabase.utf8.sql > mydatabase.utf8.sql $ echo > "SET NAMES utf8;" > tmp.sql $ cat mydatabase.utf8.sql >> tmp.sql $ mv tmp.sql mydatabase.utf8.sql Regards, Stephane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
