knokenet Posted July 15, 2003 Share Posted July 15, 2003 Hi, I'd like (for some obscure, yet meaningfull reason) to host two or more separate shops, each with its own different settings, on one SQL server. Obviously, I have to install different databases. Is it enough to rename tables on the sql file, or is there anything else needed? Link to comment Share on other sites More sharing options...
Wizzud Posted July 15, 2003 Share Posted July 15, 2003 If you are installing each 'shop' into its own database you do not need to do any renaming of tables! Each shop has its own database name declared in the configure.php files when you install. The only time you need to consider renaming tables is when you only have a single database available to run more than one osCommerce. Regards, Wizzud "It is better to remain silent and be thought a fool, than to open your mouth and remove all doubt." Link to comment Share on other sites More sharing options...
knokenet Posted July 15, 2003 Author Share Posted July 15, 2003 If you are installing each 'shop' into its own database you do not need to do any renaming of tables! Each shop has its own database name declared in the configure.php files when you install.The only time you need to consider renaming tables is when you only have a single database available to run more than one osCommerce. sorry, it is one database, not one server, ofcourse... Do I need to change any other configuration file except the sql file itself? Link to comment Share on other sites More sharing options...
Wizzud Posted July 15, 2003 Share Posted July 15, 2003 Unfortunately, what you really need is something I already have working for MS1, but have been waiting for MS2 before packaging it as a contribution! It would have done everything for you. However, the simple answer is yes, you do need to change other files. You have to change the definitions of the database table names, which are in application_top.php for MS1, and database_tables.php for MS2 (catalog and admin versions). You should be aware that the Admin Backup tool will backup everything in the database (ie. both shops at once). Therefore any restore would be of the whole database. You will also have to pay very close attention to any contributions you install that involve database modifications. Regards, Wizzud "It is better to remain silent and be thought a fool, than to open your mouth and remove all doubt." Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.