Title: Add taxonomy via phpmyadmin ?
Last modified: February 24, 2022

---

# Add taxonomy via phpmyadmin ?

 *  [boblebad](https://wordpress.org/support/users/boblebad/)
 * (@boblebad)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/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

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [mrtom414](https://wordpress.org/support/users/mrtom414/)
 * (@mrtom414)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/add-taxonomy-via-phpmyadmin/#post-15398944)
 * Here a short article on it. [https://strangework.com/2014/08/08/understanding-wordpress-taxonomy-table-relationships/](https://strangework.com/2014/08/08/understanding-wordpress-taxonomy-table-relationships/)
   maybe it will be of some help.
 *  Thread Starter [boblebad](https://wordpress.org/support/users/boblebad/)
 * (@boblebad)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/add-taxonomy-via-phpmyadmin/#post-15399509)
 * Hello [@mrtom414](https://wordpress.org/support/users/mrtom414/)
 * Thank you for your reply 🙂
 * It’s good to see how it’s connected in the database, but i’m wondering how data
   is populated. WordPress is doing all this behind the scene. As i’m not a SQL-
   coder my concern is that i need to address all three tabels and i would then 
   need to seek and match different values in all at the same time to make it work.
 * It looks like it can go wrong in many ways.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Add taxonomy via phpmyadmin ?’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)
 * [taxonomy](https://wordpress.org/support/topic-tag/taxonomy/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [boblebad](https://wordpress.org/support/users/boblebad/)
 * Last activity: [4 years, 2 months ago](https://wordpress.org/support/topic/add-taxonomy-via-phpmyadmin/#post-15399509)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics