ezorder tables

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

Author

Message

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.

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 31 2025 01:14:50
Script start
Timing:	Jan 31 2025 01:14:50
Module start 'layout'
Timing:	Jan 31 2025 01:14:50
Module start 'content'
Timing:	Jan 31 2025 01:14:50
Module end 'content'
Timing:	Jan 31 2025 01:14:50
Script end

Main resources:

Total runtime	0.0254 sec
Peak memory usage	4,096.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0050	588.0000	151.1953
Module start 'layout'	0.0050	0.0036	739.1953	220.6406
Module start 'content'	0.0086	0.0152	959.8359	997.6172
Module end 'content'	0.0238	0.0015	1,957.4531	29.9922
Script end	0.0253		1,987.4453

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0028	11.1878	14	0.0002
Check MTime	0.0012	4.8764	14	0.0001
Mysql Total
Database connection	0.0008	3.1360	1	0.0008
Mysqli_queries	0.0021	8.1082	3	0.0007
Looping result	0.0000	0.0432	1	0.0000
Template Total	0.0011	4.5	1	0.0011
Template load	0.0009	3.5925	1	0.0009
Template processing	0.0002	0.8706	1	0.0002
Override
Cache load	0.0006	2.4344	1	0.0006
General
dbfile	0.0017	6.5040	8	0.0002
String conversion	0.0000	0.0319	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