chris-hall-hu

-- Commands run whilst in the new database, the original datbase is call 'old'
-- NOTE this is an example original table etc. will need to be investigate with describe etc.

INSERT INTO taxonomy_index SELECT * FROM old.taxonomy_index;
INSERT INTO taxonomy_term_data SELECT * FROM old.taxonomy_term_data;
INSERT INTO taxonomy_term_field_data SELECT * FROM old.taxonomy_term_field_data;
INSERT INTO taxonomy_term_hierarchy SELECT * FROM old.taxonomy_term_hierarchy;

INSERT INTO node SELECT nid, vid, type, uuid, 'en' FROM old.node;
INSERT INTO node__body SELECT * FROM old.node__body;