Forums / Install & configuration / mysqldump - charset problem

"Please Note:

At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

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