Version 3.2 Beta 1 - How is it possible to install an empty database?

Previous topic

Install & configuration

Next topic

Author	Message
Thomas Nunninger	Monday 25 August 2003 1:43:08 am Hey, I just wanted to install the new beta without any package but then there are no tables initialized in the database :( How is it possible to install an empty database? Thank you Thomas
Frode Marton Meling	Monday 25 August 2003 3:30:09 am A clean database can be created by first running the kernel\sql\kernel_schema.sql and then kernel\sql\cleandata.sql with mysql. Something like this: mysql -u<username> -p<password> [database] < kernel\sql\kernel_schema.sql mysql -u<username> -p<password> [database] < kernel\sql\cleandata.sql Frode
Thomas Nunninger	Monday 25 August 2003 5:27:09 am Hey Frode, > A clean database can be created by first running the kernel\sql\kernel_schema.sql and then kernel\sql\cleandata.sql with mysql. Thanks. A short note: I found the files in kernel/sql/mysql/. But after executing this sql files there are some missing objects, e.g. in the admin interface in the user-tab (admin user). Another point: it looks very similar to the package "plain". But I think, it must be possible to initialize a working database just with less created objects, e.g. less users and groups - because I won't need them. Anybody some other suggestions? Thomas

Author

Message

Thomas Nunninger

Monday 25 August 2003 1:43:08 am

Hey,

I just wanted to install the new beta without any package but then there are no tables initialized in the database :(

How is it possible to install an empty database?

Thank you

Thomas

Frode Marton Meling

Monday 25 August 2003 3:30:09 am

A clean database can be created by first running the
kernel\sql\kernel_schema.sql and then kernel\sql\cleandata.sql with mysql.

Something like this:
mysql -u<username> -p<password> [database] < kernel\sql\kernel_schema.sql

mysql -u<username> -p<password> [database] < kernel\sql\cleandata.sql

Frode

Thomas Nunninger

Monday 25 August 2003 5:27:09 am

Hey Frode,

> A clean database can be created by first running the
kernel\sql\kernel_schema.sql and then kernel\sql\cleandata.sql with mysql.

Thanks.

A short note: I found the files in kernel/sql/mysql/. But after executing this sql files there are some missing objects, e.g. in the admin interface in the user-tab (admin user).

Another point: it looks very similar to the package "plain". But I think, it must be possible to initialize a working database just with less created objects, e.g. less users and groups - because I won't need them.

Anybody some other suggestions?

Thomas

eZ debug

Timing:	Jan 18 2025 22:28:58
Script start
Timing:	Jan 18 2025 22:28:58
Module start 'layout'
Timing:	Jan 18 2025 22:28:58
Module start 'content'
Timing:	Jan 18 2025 22:28:58
Module end 'content'
Timing:	Jan 18 2025 22:28:58
Script end

Main resources:

Total runtime	0.5581 sec
Peak memory usage	4,096.0000 KB
Database Queries	57

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0058	588.3984	152.6875
Module start 'layout'	0.0058	0.0030	741.0859	39.5234
Module start 'content'	0.0089	0.5482	780.6094	505.8984
Module end 'content'	0.5571	0.0010	1,286.5078	12.0781
Script end	0.5581		1,298.5859

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0031	0.5599	16	0.0002
Check MTime	0.0013	0.2361	16	0.0001
Mysql Total
Database connection	0.0008	0.1414	1	0.0008
Mysqli_queries	0.5149	92.2662	57	0.0090
Looping result	0.0004	0.0770	55	0.0000
Template Total	0.5305	95.1	2	0.2653
Template load	0.0018	0.3143	2	0.0009
Template processing	0.5288	94.7451	2	0.2644
Template load and register function	0.0001	0.0192	1	0.0001
states
state_id_array	0.0008	0.1414	1	0.0008
state_identifier_array	0.0008	0.1505	2	0.0004
Override
Cache load	0.0015	0.2646	26	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0005	0.0833	2	0.0002
Fetch class attribute name	0.0009	0.1682	4	0.0002
XML
Image XML parsing	0.0006	0.1071	2	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0021	5	0.0000
General
dbfile	0.0006	0.1115	16	0.0000
String conversion	0.0000	0.0016	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
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
5	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
3	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 15 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs