Forums / General / ezorder tables

ezorder tables

« 
Previous topic
|
General
|
Next topic
 »
Author Message

Mads Ovesen

Thursday 28 September 2006 2:10:02 am

Hi,

I have to move a site from one server to another. The site includes a busy webshop. The owner of the site is very interested in having the smallest possible downtime of the webshop. I was wondering if I could keep the webshop on the old server while I move the site and then just move the relevent tables for the shop afterwards. As far as I can see the ezorder tables is not dependent of the other tables in the db.

/m

Claudia Kosny

Thursday 28 September 2006 1:49:47 pm

Hi Mads

EZ does not store any server specific variables in the database. As far as I know the only relation between database and files is if there are images and other binary files to store as the storage path contains the node id and version.
So I would copy the entire installation to this new server and get Ez to run here (which should mainly be a matter of adapting site.ini, image.ini and clearing the cache). Once EZ runs fine on the new server just copy the whole database from the old server to the new server again to have the updated data. Empty the cache again and everything should be fine. This way it does not matter whether the ezorder table is linked to other tables.

Greetings from Luxembourg

Claudia

eZ debug

Timing: Jan 18 2025 15:03:28
Script start
Timing: Jan 18 2025 15:03:28
Module start 'content'
Timing: Jan 18 2025 15:03:28
Module end 'content'
Timing: Jan 18 2025 15:03:28
Script end

Main resources:

Total runtime0.7038 sec
Peak memory usage4,096.0000 KB
Database Queries191

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0065 587.5313180.8594
Module start 'content' 0.00650.5705 768.3906490.9297
Module end 'content' 0.57700.1267 1,259.3203333.5078
Script end 0.7038  1,592.8281 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00420.5955210.0002
Check MTime0.00140.2054210.0001
Mysql Total
Database connection0.00110.152610.0011
Mysqli_queries0.639690.87691910.0033
Looping result0.00200.28331890.0000
Template Total0.673695.720.3368
Template load0.00210.303120.0011
Template processing0.671595.404120.3357
Template load and register function0.00020.027610.0002
states
state_id_array0.00160.221410.0016
state_identifier_array0.00100.143820.0005
Override
Cache load0.00180.2491110.0002
Sytem overhead
Fetch class attribute can translate value0.00120.170630.0004
Fetch class attribute name0.00090.126220.0004
XML
Image XML parsing0.00050.070730.0002
class_abstraction
Instantiating content class attribute0.00000.000720.0000
General
dbfile0.00430.6040210.0002
String conversion0.00000.000830.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
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
2content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
3content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 8
 Number of unique templates used: 5

Time used to render debug report: 0.0002 secs