Setup Wizard: Install into existing DB with overriding other Tables

Next topic

Author	Message
Marco Zinn	Wednesday 29 October 2003 11:50:20 am Hi, what happens, when I install ez 3.2 with the wizard and select an existing DB, which has data in it? I can select "leave data and add new", for example. I expect, that this will dump and existing ez3 DB-tables and re-create them as needed, but will not touch OTHER (non-ez3)-Tables. Is this correct? I want to install 3.2-2 or -3 into a directory, which holds a 3.2-1 installation and use the same DB, that ez3.2-1 uses. But I want "clean" ez3-Tables (using the package data, that I need). But- as the DB also holds ez2-Tables, which I need to migrate into ez3 later, i don't want, that the wizard drops these ez2-tables. Of course, I can dump and reimport the ez2-tables, but if I don't need to do this, I scan skip this (slow) step. So: How can I keep the non-ez3-tables? Marco http://www.hyperroad-design.com
Kåre Køhler Høvik	Monday 03 November 2003 1:19:34 am Hi The "leave data and add new" only add the data needed for the 3.2 installation. If you have a previous 3.x installation in the database, it'll be corrupted. A 3.x installation will not affect the 2.2, but if you later want to upgrade the 2.2, you'll need a new database. If you have any suggestions for new options when a database contains data, please let us know. Kåre Høvik

Author

Message

Wednesday 29 October 2003 11:50:20 am

Hi,
what happens, when I install ez 3.2 with the wizard and select an existing DB, which has data in it?
I can select "leave data and add new", for example.
I expect, that this will dump and existing ez3 DB-tables and re-create them as needed, but will not touch OTHER (non-ez3)-Tables.
Is this correct?
I want to install 3.2-2 or -3 into a directory, which holds a 3.2-1 installation and use the same DB, that ez3.2-1 uses.
But I want "clean" ez3-Tables (using the package data, that I need).
But- as the DB also holds ez2-Tables, which I need to migrate into ez3 later, i don't want, that the wizard drops these ez2-tables.
Of course, I can dump and reimport the ez2-tables, but if I don't need to do this, I scan skip this (slow) step.
So: How can I keep the non-ez3-tables?

Marco
http://www.hyperroad-design.com

Kåre Køhler Høvik

Monday 03 November 2003 1:19:34 am

The "leave data and add new" only add the data needed for the 3.2 installation. If you have a previous 3.x installation in the database, it'll be corrupted.

A 3.x installation will not affect the 2.2, but if you later want to upgrade the 2.2, you'll need a new database.

If you have any suggestions for new options when a database contains data, please let us know.

Kåre Høvik

eZ debug

Timing:	Jan 31 2025 08:05:35
Script start
Timing:	Jan 31 2025 08:05:35
Module start 'layout'
Timing:	Jan 31 2025 08:05:35
Module start 'content'
Timing:	Jan 31 2025 08:05:36
Module end 'content'
Timing:	Jan 31 2025 08:05:36
Script end

Main resources:

Total runtime	0.6319 sec
Peak memory usage	4,096.0000 KB
Database Queries	54

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0059	588.6172	151.2734
Module start 'layout'	0.0059	0.0032	739.8906	36.7266
Module start 'content'	0.0091	0.6219	776.6172	925.0938
Module end 'content'	0.6309	0.0009	1,701.7109	7.9219
Script end	0.6318		1,709.6328

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0038	0.5970	16	0.0002
Check MTime	0.0019	0.2953	16	0.0001
Mysql Total
Database connection	0.0010	0.1541	1	0.0010
Mysqli_queries	0.5767	91.2722	54	0.0107
Looping result	0.0005	0.0759	52	0.0000
Template Total	0.5931	93.9	2	0.2966
Template load	0.0020	0.3137	2	0.0010
Template processing	0.5911	93.5493	2	0.2956
Template load and register function	0.0012	0.1918	1	0.0012
states
state_id_array	0.0014	0.2253	1	0.0014
state_identifier_array	0.0011	0.1809	2	0.0006
Override
Cache load	0.0017	0.2616	20	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0009	0.1398	2	0.0004
Fetch class attribute name	0.0022	0.3458	4	0.0005
XML
Image XML parsing	0.0022	0.3428	2	0.0011
class_abstraction
Instantiating content class attribute	0.0000	0.0016	4	0.0000
General
dbfile	0.0039	0.6128	21	0.0002
String conversion	0.0000	0.0014	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
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
2	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 9 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs