The SQL schemas for new databases are placed in kernel/sql You need to set the database username and password manually before you insert this content into the database (you do this with a GRANT ... function). For more information about this, check the installation documentation in the eZ publish distribution
Jo Henrik Endrerud | System Developer @ Seeds Consulting | http://www.seeds.no
Have you sucefully configure multiple sites using one database for each site ?
Just trying to do the same. See my other post at http://ez.no/developer/ez_publish_3/forum/setup_design/how_use_different_databases_for_different_sites_with_some_ez_instalation_
yes i did it. look at the ez manuals here in the web, at the "install manually" section (http://ez.no/manual/install/install_manually) you can find the way to create and configure the database to have the correct structure of tables. then the only thing is to create a new siteaccess with the correct information of the database you created.
if you don't configure new domains you can access the new site by http://your_host/index.php/newsite/
I forgot come where to announce my sucess configuring multidatabase.
So simple like this (ezp 3.1):
- Copy settings\siteaccess\demo\ to settings\siteaccess\your_site_name\ - This creates a new dir of settings for the new site
- Copy settings\siteaccess\amin\ to settings\siteaccess\your_site_name_admin\ - This creates a new dir iof settings to admin new site
- Using myphpadmin, mysql console or other mysql manager utility copy the database created at instalation to a database with the name your_site_name. Using windows, go to mysql\data\install_database_name and do a copy&paste to create a DB copy. Rename it. - Edit settings\siteaccess\your_site_name\site.ini.append and settings\siteaccess\your_site_name_admin\site.ini.append. Look at [DatabaseSettings] and change the settings to the new database.
- Browse http://your_domain/your_site_name/ to see the new site using the new database. http://your_domain/your_site_name_admin/ to admin the new site.