mysqldump - charset problem

Next topic

Author	Message
Artturi Markko	Sunday 28 May 2006 8:51:40 am Hello, I was running Ez 3.7.5 and made a backup via phpmyadmin before upgrading to ez 3.8.0. My setup is apache 1.33, windows 2003, and mysql 4.1.12-nt The only defined charset I've found in the ini settings come from i18n.ini and is : [CharacterSettings] Charset=iso-8859-1 HTTPCharset= MBStringExtension=enabled The problem is that the backup contains strange characters instead of accents and when restored, all accents are replaced with things like this : dÃ©pÃ´t des thÃ¨sesdÃ©pÃ´t des thÃ¨ses 1) Is there a way to get my accents back ? 2) What have I done wrong / what should I do to create a good backup ? Thanks in advance, Artturi
Artturi Markko	Sunday 28 May 2006 12:46:33 pm I've just tested to dump a database with this syntax : mysqldump --default-character-set=latin1 database > file.sql and file.sql's content respects all the accents. It seems to be a phpmyadmin problem (reading mysql's documentation : --default-character-set=charset_name Use charset_name as the default character set. See Section 5.11.1, “The Character Set Used for Data and Sorting”. If not specified, mysqldump uses utf8. Artturi

Author

Message

Sunday 28 May 2006 8:51:40 am

Hello,

I was running Ez 3.7.5 and made a backup via phpmyadmin before upgrading to ez 3.8.0.
My setup is apache 1.33, windows 2003, and mysql 4.1.12-nt

The only defined charset I've found in the ini settings come from i18n.ini and is :

[CharacterSettings]
Charset=iso-8859-1
HTTPCharset=
MBStringExtension=enabled

The problem is that the backup contains strange characters instead of accents and when restored, all accents are replaced with things like this :

dÃ©pÃ´t des thÃ¨sesdÃ©pÃ´t des thÃ¨ses

1) Is there a way to get my accents back ?
2) What have I done wrong / what should I do to create a good backup ?

Thanks in advance,

Artturi

Artturi Markko

Sunday 28 May 2006 12:46:33 pm

I've just tested to dump a database with this syntax :

mysqldump --default-character-set=latin1 database > file.sql

and file.sql's content respects all the accents.

It seems to be a phpmyadmin problem (reading mysql's documentation :

--default-character-set=charset_name

Use charset_name as the default character set. See Section 5.11.1, &#8220;The Character Set Used for Data and Sorting&#8221;. If not specified, mysqldump uses utf8.

Artturi