How to create a new database "from scratch"?

Next topic

Author	Message
Eric Weik	Friday 13 February 2004 9:22:10 pm When setting up a new site from scratch (ie. without using the setup wizard), what is the best way to actually build the new database (in MySQL)? Obviously, you need to create a new database and user: mysqladmin create ezp_newsite (and add your new user and privileges). But then you just have an enpty database. To set up my prototype, I made a copy of the "plain" example database like so: mysqldump ezp_example_plain > /tmp/ezp_example_plain.sql mysql ezp_newsite < /tmp/ezp_example_plain.sql Is there a better way to go about this? Thanks, Eric
Marco Zinn	Sunday 15 February 2004 5:50:37 am I think, there are some .sql files like "clean_data" or "kernel_schema" around. One just sets up the tables, the other also fills in some data (like the admin user), which you need. Marco http://www.hyperroad-design.com

Author

Message

Friday 13 February 2004 9:22:10 pm

When setting up a new site from scratch (ie. without using the setup wizard), what is the best way to actually build the new database (in MySQL)?

Obviously, you need to create a new database and user:
mysqladmin create ezp_newsite
(and add your new user and privileges).

But then you just have an enpty database. To set up my prototype, I made a copy of the "plain" example database like so:
mysqldump ezp_example_plain > /tmp/ezp_example_plain.sql
mysql ezp_newsite < /tmp/ezp_example_plain.sql

Is there a better way to go about this?

Thanks,
Eric

Marco Zinn

Sunday 15 February 2004 5:50:37 am

I think, there are some .sql files like "clean_data" or "kernel_schema" around.
One just sets up the tables, the other also fills in some data (like the admin user), which you need.

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