Christopher David Hall chris-hall-hu

chris-hall-hu / sql.sql

Created January 2, 2016 08:45

Example sql migration for late Beta Drupal 8 to 8.01

	-- 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;