How to create a new database "from scratch"?

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