Forums / Install & configuration / Version 3.2 Beta 1 - How is it possible to install an empty database?

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