Hello David
I have Two setup of pricetapestry with different DB
I want to copy Category,product,and mapping from one database to another which should not affect another functionality
I am going to copy tables products,productsmap,categories_hierarchy
Using SQl
DROP TABLE IF EXISTS DB1.products;
CREATE TABLE DB1.products LIKE pricetapestry_new.products;
INSERT DB1.products SELECT * FROM pricetapestry_new.products;
DROP TABLE IF EXISTS DB1.productsmap;
CREATE TABLE DB1.productsmap LIKE pricetapestry_new.productsmap;
INSERT DB1.productsmap SELECT * FROM pricetapestry_new.productsmap;
DROP TABLE IF EXISTS DB1.categories_hierarchy;
CREATE TABLE DB1.categories_hierarchy LIKE pricetapestry_new.categories_hierarchy;
INSERT DB1.categories_hierarchy SELECT * FROM pricetapestry_new.categories_hierarchy;
Let me know I am right or any other tables required to copy
Hi,
Since `productsmap` and `categories_hierarchy` are only referred to at import time, that would imply that the pricetapestry_new database is a full Price Tapestry installation (i.e. with feeds and /admin/ area in use) rather than just a slave installation pointing at the same database as a master installation) in which case, it is probably best not to copy across `products`.
Instead, after duplicating `productsmap` and `categories_hierarchy` as per your proposed SQL (which looks fine), then simply run a full import on the pricetapestry_new installation to populate `products`...
Cheers,
David.
--
PriceTapestry.com