You are here:  » Coping Table from one database to another


Coping Table from one database to another

Submitted by keshavkshirsagar on Thu, 2015-08-27 11:48 in

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

Submitted by support on Thu, 2015-08-27 12:13

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