Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Shared SQL Database


Recommended Posts



I have a slight problem that one of my clients wishes to launch a few shops but wants to use just one database, therefore if I install a new osCommerce over the top of the site then I can see that there are going to be some problems in it overwriting everything.


Therefore would me changing the SQL data to give the new shops tables each a prefix for example "one_customers" and "two_customers" etc work?


If so how would I go about doing this, would I just need to change the database_names.php file or is there alot more too it?





Link to comment
Share on other sites

This is kind of pointless. There are several solid hosting companies offering setups with multiple databases for very reasonable prices.


Any solution which involves layering more than one store into a single database is bound to cause problems. It's unnecessary in today's environment.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...