One Database --> OsCommerce Prefix

[wquatan]

Hi,

 

I have been searching around but couldn't find an answer to my problem :

My provider only allows me to have one MySql database. Other installation-scripts allowed me to define a database-Prefix. This allows me to install multiple instances of the same package.

 

But how can I do this in osCommerce ? Here and there I saw references that it should be possible, but couldn't find the answer for "how".

 

Thx

[FIMBLE]

Have you thought about changing hosts?

Nic

[wquatan]

Have you thought about changing hosts?

Nic

Meaning I should understand that the answer is : Can't be done with osCommerce

[♥FWR Media]

Ok this is a quick suggestion not a "tested and definate fix".

Back up your database before trying as this may destroy it!!!

 

Ok you have one shop installed via the standard osC installer right?

 

If so .. then do the following: -

 

Upload all of the osCommerce files to a different directory on your hosting package.

 

Don't install yet .. open up the file where_ever_you-put_me/install/oscommerce.sql

 

Find all instances of "DROP TABLE IF EXISTS" and delete them.

 

Then ...

 

Find all instances of CREATE TABLE and add a number plus an underscore _

 

So CREATE TABLE address_book

 

would become e.g CREATE TABLE 1_address_book

 

Once you have done this for all instances of "CREATE TABLE" save the file then install using the same user database pass as the original install.

 

You should now have a database duplicated with tables like ..

 

address_book = first install

 

1_address_book = second install

 

if you add another it would be ..

 

2_address_book = third install

 

Now you need to alter two files ..

 

1) catalog/includes/database_tables

2) catalog/admin/includes/database_tables

 

Change every define to add the ( number _ table )

 

So ..

 

define('TABLE_ADDRESS_BOOK', 'address_book');

 

Would become ..

 

define('TABLE_ADDRESS_BOOK', '1_address_book');

 

That should do it I think.

[wquatan]

That should do it I think.

 

Thank you very much for your input ! Was very usefull !

 

Based upon that I made a batch-file which prepares the installation before uploading it to the provider.

Probably it can been optimized, but it works.

The zip-file must be unzipped in the directory containing the Catalog-directory, the batch-file fired with the prefix needed. After that, upload and installation upload as usual.

 

Unfortunatly it seems not possible to add files in this forum, otherwise I would have attached it