Welcome, Guest ( Customer Panel | Login )




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

jensop
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?

Cam
VP-CART Super User

Australia
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.

Cheers,
Cam

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

Build you own YourVirtualStore!!!
www.yourvirtualstore.net
*************************************
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00