VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-Cart StoreFront Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Mysql database HELP!!
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

4 Posts

Posted - February 09 2003 :  08:40:59  Show Profile  Reply with Quote
I have a hotel that only supports ONE mysql database pr. hotel - Does anyone know how to place a second copy of the VP-ASP tables inside an existing database that already have VPASP tables?<br>pehaps it could be placed in a new table between the original tables of VPASP?

VP-ASP Super User

361 Posts

Posted - February 12 2003 :  04:37:23  Show Profile  Visit Cam's Homepage  Reply with Quote
I am not 100% on what you are after but you could perhaps create a whole new folder for your 2nd hotel.

Now open the scripts for creating the MYSql Db and change the table name references to something new for example products could become productsH2 to refer to the fact that it is for the 2nd hotel. This way all tables added into the db will be separate from the existing ones.

Then do a sitewide search of the new folder to find all references to the products table and change to the new name.

Then do the same for the rest of the tables. It would be a very slow process though as you would have to do the changes individually rather than a general site wide change.

I could be totally off on one though as i am not totally sure if I grasped your problem correctly.


Cam Flanigan
YourVirtualStore Sales
e-mail: http://www.vpasp.com/sales/shopcustcontact.asp
web: http://www.yourvirtualstore.net

Build you own YourVirtualStore!!!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000