how to create multisite with different databases?

Tuesday 20 May 2003 9:53:19 am

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

Friday 13 June 2003 7:23:25 pm

Hi Albert,

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_

Thanks

axel

http://AlexandreCunha.com

Wednesday 02 July 2003 4:34:29 pm

Thanks Albert,

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.

Maybe this helps someone else.

axel

http://AlexandreCunha.com