multiple osc sites on webserver

[Rodland]

Hi,

I want to create and test different osc sites, some perhaps with different snapshots, on my apache webserver on my local computer (Jaguar). I already have one working as such:

http://myhomeserver/catalog/
http://myhomeserver/admin/

I have phpMyAdmin installed and have created a database called "catalog".

First of all, if I want to install and test the different sites at once on my server, such as this:

http://myhomeserver/site1/catalog/
http://myhomeserver/site1/admin/

http://myhomeserver/site2/catalog/
http://myhomeserver/site2/admin/

what changes do I need to make in configure.php, application_top.php and other files to do this correctly?

Also, in phpMyAdmin, I have my old database installed and called 'catalog'. Do I simply upload a new database for each site and name them something different or do I erase the existing database and create a new one? Do they both HAVE to be called 'catalog' and if so are there any pages which I need to configure to coincide with the database name?

Also, do I need to make any further changes in passwords etc, to mySQL?

CMR

[michael_s]

You are on the right track. Every instance of osCommerce needs its own database, such as catalog1, catalog2, etc... (you can name the db whatever you like, just make sure you enter the correct name in the install script)

Each install should be in its own home directory, like you show above, site1, site2, etc.

Run the install script for each separate installation, and you should have no troubles. Make sure the paths that the install script uses actually reflect the true paths of each install.

[Rodland]

Great, thanks!

What then do I need to configure if I wanted to start by putting an existing osC site from http://myhomeserver/ to http://myhomeserver/site1/ ?

Also would these file be exactly the same files I would need to change again when it comes to uploading the site to the actual web server after getting rid of the site1/ folder?


A database question: If I want to change the name of a database within phpMyAdmin from say catalog to catalog1, after I have used the install script, which files within admin/ or catalog/ do I need to configure manually to coincide with the database name change?

Thanks again,

CMR

[av8er]

If you want to move the site from http://myhomeserver/ to http://myhomeserver/site1/ just create the site one folder and move all the files over there. The you'll have to manually edit /catalog/includes/configure.php to show the new path of your site. You'll have to do the same with /catalog/admin/includes/configure.php.

I couldn't get the install script to work and had to do a manual install, that's how I know this works. I know the exact lines you need to change as well, I just don't have it with me right now. I'll look it up first thing in the morning and post it for you.

Also, I wouldn't change the name of the database, I think you might be asking for trouble if you do that. If anything maybe export the structure & data using PHPMyadmin and create the new database and upload the structure & data to the new one. (I'm new to databases so I could be wrong).

Good luck