Add taxonomy via phpmyadmin ?

Hello

I work in Pods where i have to magazines.

When i started this project i didn’t think of adding the 2nd magazine, so i didn’t prepare a field to chose between them. I have now added a Custom Taxonomy for this now, and the import of the 2nd magazine is using it, so i can chose to display only that magazine.

Now to my problem.

I can easily add a column in Excel and do a new import, but there’s close to 90 volumes with on average 10 issues. In total there’s over 11.000 articles i need to add that new Custom Taxonomy to.

I have been looking in phpmyadmin and tried to figure out what i need to address to do the update/addition via SQL, but i can’t find the right place where it’s stored. I can find when i search the term for the 2nd magazine, the wp_term_relationships, but it only holds the ID’s of the Custom Post Type where the taxonomy relates to.

So how do i get around this, seeking out those 11.000 Pods “Articles” and add a Custom Taxonomy “Kosmos” to them ?

All the best
Carsten