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

eZ debug

Timing:	Jan 18 2025 18:21:34
Script start
Timing:	Jan 18 2025 18:21:34
Module start 'layout'
Timing:	Jan 18 2025 18:21:34
Module start 'content'
Timing:	Jan 18 2025 18:21:34
Module end 'content'
Timing:	Jan 18 2025 18:21:34
Script end

Main resources:

Total runtime	0.6170 sec
Peak memory usage	4,096.0000 KB
Database Queries	52

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0054	589.1484	152.6250
Module start 'layout'	0.0054	0.0030	741.7734	39.4453
Module start 'content'	0.0085	0.6068	781.2188	428.3125
Module end 'content'	0.6153	0.0016	1,209.5313	8.1641
Script end	0.6169		1,217.6953

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0036	0.5799	16	0.0002
Check MTime	0.0015	0.2397	16	0.0001
Mysql Total
Database connection	0.0006	0.1020	1	0.0006
Mysqli_queries	0.5697	92.3374	52	0.0110
Looping result	0.0004	0.0712	50	0.0000
Template Total	0.5832	94.5	2	0.2916
Template load	0.0019	0.3068	2	0.0009
Template processing	0.5813	94.2144	2	0.2906
Template load and register function	0.0001	0.0219	1	0.0001
states
state_id_array	0.0007	0.1133	1	0.0007
state_identifier_array	0.0013	0.2057	2	0.0006
Override
Cache load	0.0015	0.2467	21	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0007	0.1054	1	0.0007
Fetch class attribute name	0.0009	0.1509	2	0.0005
XML
Image XML parsing	0.0001	0.0179	1	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0008	2	0.0000
General
dbfile	0.0057	0.9245	10	0.0006
String conversion	0.0000	0.0012	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
6	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
2	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
2	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 14 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs