installing multiple osC on same Db

[Guest]

hello gurus !

 

i really want to install multiple instances of osC on the same DB server. i only have access to one db but i need to run 5 different shops with 5 difference domain names (one each .. duh :P )

 

i need to add a prefix to all sql entries . like . sp1 for shop1 and sp2 for shop2 etc.

 

I presume i change things in the /install/includes and install/includes/functions folder

maybe even things in the /admin folder ?

 

i know everything needs to be differant so none of the categories cross connect with each others shops but i asume if i change the installer . all the sql create catagories and products stuff will change..

 

i am no good at mysql or php , but my brain works logicaly should be able to follow any helpful replies !

 

Thanks in advance for any help !

 

alistair,

[Guest]

When you install it, if it gives you the option for a prefix simply add new pre-fix and enter the mySQL DB details for that DB.

 

Although, maybe you should consider upgrading your hosting account! You are either paying a ridiculously low amount and getting little or getting ripped off.

For example, digitalracks offer multiple DB's on a 2.59GBP package.

[Guest]

When you install it, if it gives you the option for a prefix simply add new pre-fix and enter the mySQL DB details for that DB.

 

Although, maybe you should consider upgrading your hosting account! You are either paying a ridiculously low amount and getting little or getting ripped off.

For example, digitalracks offer multiple DB's on a 2.59GBP package.

 

thanks for the sponcered plug ;)

i am with 1and1 and they are giving me a number of db , but i want 5 shops with 5 different domians on the same DB to keep the same shop type grouped together nicely as i will be launching 174 online shops before this year ( 54 of which should be online before march [ yikes ] )

 

unfortunatly there is no such option when installing using the /install/install.php

[chooch]

Let me get this straight... you want 5 stores all with one central DB?

 

If I understand what you want to do correctly, you can have as many as you want connected to the same DB - I presume they will be on the smae server?

 

Anyway, all you have to do is to change the catalog/includes/configure and admin/includes/configure files in the portion that requires the DB username and password.... (that's if I understand correctly what you are trying to do)

[Guest]

Let me get this straight... you want 5 stores all with one central DB?

 

If I understand what you want to do correctly, you can have as many as you want connected to the same DB - I presume they will be on the smae server?

 

Anyway, all you have to do is to change the catalog/includes/configure and admin/includes/configure files in the portion that requires the DB username and password.... (that's if I understand correctly what you are trying to do)

 

yes, your have almost got the idea. i need to change somthing so all the tables that area created in the MySQL database ( with the same Db number , same db user name and same db pasword ) have a prefix number.

 

E.g

 

shop one sells salon equipment so i can call it shop1

shop two sells adult toys i'm gonna call it shop2

shop three sells womans accessories i'll call it shop3

 

i need the install script to do somthing like this

 

shop1

CREATE TABLE categories (

same as normall..

 

but when i install shop two into the exact same Mysql database

i need to prefix all tables to make then unique

 

shop2

CREATE TABLE 2categories (

etc.

 

shop3

CREATE TABLE 3categories (

etc.

 

is there an option to prefix the standard installer to globally change the way it installs and creates tables ?

 

 

thanks for the replies so far.

 

please keep offering sugestions !

 

alistair,

[♥Vger]

Top of this page --> Community --> Contributions --> Multi-Stores - allows you to run multiple shops from one db and with one admin panel (with different levels of access for each shop).

 

Vger

[Guest]

Top of this page --> Community --> Contributions --> Multi-Stores - allows you to run multiple shops from one db and with one admin panel (with different levels of access for each shop).

 

Vger

 

spot on..

 

thanks for the link.. i will update post with outcome of install and anthing i did to make things work.

 

Thanks again Vger !

[Guest]

spot on..

 

thanks for the link.. i will update post with outcome of install and anthing i did to make things work.

 

Thanks again Vger !

 

 

Yup , thats worked :) thanks for the contrib !

 

one more thing.. ( will post in a different topic is there such a thing as a osC with a auto thumbnail tool already patched in ? as i am having trouble with nearly every contrib i'm finding on osC community !

 

thanks,

[cabachona]

Top of this page --> Community --> Contributions --> Multi-Stores - allows you to run multiple shops from one db and with one admin panel (with different levels of access for each shop).

 

Vger

Hi, I am wanting to test some of the contribs to a test site, yet don't know how to set one up. I have my live data up and running now thanks to everyone who has been a great help in enabling me to recover from the shock of discovering I had all but "wiped" everything out simply by not knowing that I should put a \ before the ' eg: sarah\'s shop. I also tried installing another whole OsCommerce into my site without realising it would over-write everything and lost the whole darn bit. all this fun certainly took years off my age (or added them onto.)anyway now I am online and want to "pretty it up by adding some colour ect. However I would feel happier now if I had a test site I could practise safely on before going "live". Can you please give me some pointers. Thanks so much. :blink: :rolleyes: :)