Forums / General / Migrating from PostgreSQL to MySQL

Migrating from PostgreSQL to MySQL

« 
Previous topic
|
General
|
Next topic
 »
Author Message

Jonas Helgemo

Wednesday 18 February 2009 6:28:31 am

I have an eZ site that is currently using PostgreSQL, but I need to migrate it to MySQL in order to move the site to a different server where the only possibility is to use MySQL. Is it possible to export the data from eZ to some standard format without having to deal with the database dumps (e.g some import/export function in eZ)? I have considered using some kind of PostgreSQL -> MySQL converter, but I'm not sure it would work with the complex database structure used in eZ. Any ideas or experiences on how to migrate the database backend from PostgreSQL to MySQL?

juan uribe

Sunday 08 March 2009 9:57:40 pm

hi, hopefully you will read this... and replay..

I´m thinking also on migrating from postgreSQL to MySQL. For a very strange reason. My postgresql seems very unstable. My server runs two ez installs side by side, one on postgres and one on mysql. Mysql is strangelly enough faster and more stable.

So I wanted to ask 1) after migrating how was performance 2) how did you achive the migration...

Thanks---

eZ debug

Timing: Jan 18 2025 11:21:29
Script start
Timing: Jan 18 2025 11:21:29
Module start 'content'
Timing: Jan 18 2025 11:21:29
Module end 'content'
Timing: Jan 18 2025 11:21:29
Script end

Main resources:

Total runtime0.1612 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0080 587.7109180.8359
Module start 'content' 0.00800.0063 768.546993.6484
Module end 'content' 0.01430.1468 862.1953522.1719
Script end 0.1611  1,384.3672 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00342.1021200.0002
Check MTime0.00140.8404200.0001
Mysql Total
Database connection0.00171.028010.0017
Mysqli_queries0.116972.55221410.0008
Looping result0.00120.75241390.0000
Template Total0.146590.910.1465
Template load0.00070.407710.0007
Template processing0.145990.495910.1459
Override
Cache load0.00050.291710.0005
Sytem overhead
Fetch class attribute can translate value0.00050.305910.0005
XML
Image XML parsing0.00020.134010.0002
General
dbfile0.00140.8797200.0001
String conversion0.00000.003130.0000
Note: percentages do not add up to 100% because some accumulators overlap

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

CacheTypePacklevelSourceFiles
CSS0extension/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
JS0extension/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:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs