I imported about a thousand terms into the terms_data table and then added the parent-child relationships in the terms_hiearchy table. Everything went smoothly until I tried to add a term manually in another vocabulary using the "add terms" UI in taxonomy.
a.. user warning: Duplicate entry '126' for key 1 query: INSERT INTO term_data (tid, name, description, vid, weight) VALUES (126, '2000s', '', 6, 0) in /home/mysite/public_html/includes/database.mysql.inc on line 172. b.. user warning: Duplicate entry '126' for key 1 query: INSERT INTO xmlsitemap_term (tid, pid, last_changed, priority_override) VALUES (126, NULL, 1212242801, NULL) in /home/mysite/public_html/includes/database.mysql.inc on line 172. the auto increment for these tables should be over 1000 and is showing as such in phpmyadmin - is that value stored somewhere where I can alter it?
If I manually enter terms into the _data and _hierarchy tables, is there something else I need to alter to avoid problems when I go back to manually adding terms?
Neil