Forums / Install & configuration / how to create multisite with different databases?

how to create multisite with different databases?

« 
Previous topic
|
Install & configuration
|
Next topic
 »
Author Message

Albert Berenguer

Tuesday 20 May 2003 9:34:18 am

hi!
i want to create multiple sites with only one installation of eZ Publish and also with one database per site, but, how do i create new databases with the correct structucte of tables?
then the user and the password for connecting to the new database is the same as the default one?

thanks

berto

Jo Henrik Endrerud

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

Albert Berenguer

Wednesday 21 May 2003 9:04:56 am

thanks for all! although i had to run the sql file using phpMyAdmin (because i wasn't able using command line...) everything went right.

thanks

Alexandre Cunha

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

Albert Berenguer

Wednesday 02 July 2003 7:20:17 am

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/

hope it was helpfull, bye!

Alexandre Cunha

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