Forums / Developer / PostGress -> Mysql : Import package problem

PostGress -> Mysql : Import package problem

Previous topic

Developer

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

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

eZ debug

Timing:

Jan 31 2025 05:33:50

Script start

Timing:

Jan 31 2025 05:33:50

Module start 'content'

Timing:

Jan 31 2025 05:33:50

Module end 'content'

Timing:

Jan 31 2025 05:33:50

Script end

Main resources:

Total runtime

0.1616 sec

Peak memory usage

2,048.0000 KB

Database Queries

141

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0103	588.0313	180.8281
Module start 'content'	0.0103	0.0076	768.8594	89.8047
Module end 'content'	0.0179	0.1437	858.6641	518.3750
Script end	0.1616		1,377.0391

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0103

588.0313

180.8281

Module start 'content'

0.0103

0.0076

768.8594

89.8047

Module end 'content'

0.0179

0.1437

858.6641

518.3750

Script end

0.1616

1,377.0391

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0041	2.5121	20	0.0002
Check MTime	0.0015	0.9391	20	0.0001
Mysql Total
Database connection	0.0014	0.8667	1	0.0014
Mysqli_queries	0.1067	66.0134	141	0.0008
Looping result	0.0013	0.7890	139	0.0000
Template Total	0.1433	88.7	1	0.1433
Template load	0.0011	0.6742	1	0.0011
Template processing	0.1422	87.9856	1	0.1422
Override
Cache load	0.0008	0.5179	1	0.0008
Sytem overhead
Fetch class attribute can translate value	0.0009	0.5443	1	0.0009
XML
Image XML parsing	0.0003	0.2140	1	0.0003
General
dbfile	0.0104	6.4531	20	0.0005
String conversion	0.0000	0.0080	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Accumulator

Duration (sec)

Duration (%)

Count

Average (sec)

Ini load

Load cache

0.0041

2.5121

0.0002

Check MTime

0.0015

0.9391

0.0001

Mysql Total

Database connection

0.0014

0.8667

0.0014

Mysqli_queries

0.1067

66.0134

141

0.0008

Looping result

0.0013

0.7890

139

0.0000

Template Total

0.1433

88.7

0.1433

Template load

0.0011

0.6742

0.0011

Template processing

0.1422

87.9856

0.1422

Override

Cache load

0.0008

0.5179

0.0008

Sytem overhead

Fetch class attribute can translate value

0.0009

0.5443

0.0009

XML

Image XML parsing

0.0003

0.2140

0.0003

General

dbfile

0.0104

6.4531

0.0005

String conversion

0.0000

0.0080

0.0000

Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

Cache	Type	Packlevel	SourceFiles
	CSS	0	extension/community/design/community/stylesheets/ext/jquery.autocomplete.css extension/community_design/design/suncana/stylesheets/scrollbars.css extension/community_design/design/suncana/stylesheets/tabs.css extension/community_design/design/suncana/stylesheets/roadmap.css extension/community_design/design/suncana/stylesheets/content.css extension/community_design/design/suncana/stylesheets/star-rating.css extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css extension/community_design/design/suncana/stylesheets/buttons.css extension/community_design/design/suncana/stylesheets/tweetbox.css extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css extension/sevenx/design/simple/stylesheets/star_rating.css extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css extension/sevenx/design/simple/stylesheets/main.v02.css extension/sevenx/design/simple/stylesheets/main.v02.res.css
	JS	0	extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js extension/community_design/design/suncana/javascript/jquery.ui.core.min.js extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js extension/community_design/design/suncana/javascript/jquery.easing.1.3.js extension/community_design/design/suncana/javascript/jquery.ui.tabs.js extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js extension/community_design/design/suncana/javascript/jquery.popmenu.js extension/community_design/design/suncana/javascript/jScrollPane.js extension/community_design/design/suncana/javascript/jquery.mousewheel.js extension/community_design/design/suncana/javascript/jquery.cycle.all.js extension/sevenx/design/simple/javascript/jquery.scrollTo.js extension/community_design/design/suncana/javascript/jquery.cookie.js extension/community_design/design/suncana/javascript/ezstarrating_jquery.js extension/community_design/design/suncana/javascript/jquery.initboxes.js extension/community_design/design/suncana/javascript/app.js extension/community_design/design/suncana/javascript/twitterwidget.js extension/community_design/design/suncana/javascript/community.js extension/community_design/design/suncana/javascript/roadmap.js extension/community_design/design/suncana/javascript/ez.js extension/community_design/design/suncana/javascript/ezshareevents.js extension/sevenx/design/simple/javascript/main.js

Cache

Type

Packlevel

SourceFiles

CSS

extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css

extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	pagelayout.tpl	<No override>	extension/sevenx/design/simple/templates/pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Usage

Requested template

Template

Template loaded

Edit

Override

pagelayout.tpl

<No override>

extension/sevenx/design/simple/templates/pagelayout.tpl

Number of times templates used: 1
Number of unique templates used: 1

Time used to render debug report: 0.0002 secs