PostGress -> Mysql : Import package problem

Next topic

Author	Message
Pierre Tissot	Tuesday 13 November 2007 3:00:02 am Hello, I'm trying to change my database, importing data from one server (in postgres) to another one (in mysql). In order to do so I use packages. My problem is that the imported node_ids are different from the original, so all my structure of site override and templeting are wrong. Is there any way to force the package to maintain this node integrity between the two versions? Is there any tool that somebody know that can translate a postgress database dump to mysql format? best regards PiR

Author

Message

Tuesday 13 November 2007 3:00:02 am

Hello,

I'm trying to change my database, importing data from one server (in postgres) to another one (in mysql). In order to do so I use packages. My problem is that the imported node_ids are different from the original, so all my structure of site override and templeting are wrong.

Is there any way to force the package to maintain this node integrity between the two versions?

Is there any tool that somebody know that can translate a postgress database dump to mysql format?

best regards
PiR

eZ debug

Timing:	Jan 18 2025 23:05:06
Script start
Timing:	Jan 18 2025 23:05:06
Module start 'layout'
Timing:	Jan 18 2025 23:05:06
Module start 'content'
Timing:	Jan 18 2025 23:05:06
Module end 'content'
Timing:	Jan 18 2025 23:05:06
Script end

Main resources:

Total runtime	0.0210 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0066	588.0313	152.6406
Module start 'layout'	0.0066	0.0032	740.6719	39.4609
Module start 'content'	0.0098	0.0089	780.1328	85.2422
Module end 'content'	0.0187	0.0023	865.3750	30.3047
Script end	0.0210		895.6797

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0030	14.2339	14	0.0002
Check MTime	0.0012	5.7203	14	0.0001
Mysql Total
Database connection	0.0016	7.4146	1	0.0016
Mysqli_queries	0.0028	13.4366	3	0.0009
Looping result	0.0000	0.0624	1	0.0000
Template Total	0.0019	8.9	1	0.0019
Template load	0.0011	5.0285	1	0.0011
Template processing	0.0008	3.8196	1	0.0008
Override
Cache load	0.0006	2.8817	1	0.0006
General
dbfile	0.0036	17.1088	8	0.0004
String conversion	0.0000	0.0465	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	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs