Forums / Install & configuration / mysqldump - charset problem

mysqldump - charset problem

Previous topic

Install & configuration

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

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, &#8220;The Character Set Used for Data and Sorting&#8221;. If not specified, mysqldump uses utf8.

Artturi