Script to replace new term ID with new ones
If you want to replace a taxonomy term with another one and want it replaced at the node you can fill in this form and send it as an SQL query in phpMyAdmin.
But if you just want to move around in taxonomy, the Taxonomy Manager is absolutely fantastic if you just have your taxonomy stored as term, not in CCK. Taxonomy Manager won't have any effect in CCK.
USE my_database;
#######################################################
#Type term ID to be removed at '@removeme'
#New term ID to replace '@removeme' is set by '@new'
SET @removeme = 0;
SET @new = 0;
DELETE FROM term_data WHERE tid = @removeme LIMIT 1;
DELETE FROM term_hierarchy WHERE tid = @removeme ;
UPDATE term_node SET tid= @new WHERE tid = @removeme ;
#########
#######################################################
#Type term ID to be removed at '@removeme'
#New term ID to replace '@removeme' is set by '@new'
SET @removeme = 0;
SET @new = 0;
DELETE FROM term_data WHERE tid = @removeme LIMIT 1;
DELETE FROM term_hierarchy WHERE tid = @removeme ;
UPDATE term_node SET tid= @new WHERE tid = @removeme ;
#########
#######################################################
#Type term ID to be removed at '@removeme'
#New term ID to replace '@removeme' is set by '@new'
SET @removeme = 0;
SET @new = 0;
DELETE FROM term_data WHERE tid = @removeme LIMIT 1;
DELETE FROM term_hierarchy WHERE tid = @removeme ;
UPDATE term_node SET tid= @new WHERE tid = @removeme ;
#########
Knowledge keywords: