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?

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