WordPress’ terms and taxonomies are spread over three tables in the database. Those tables are wp_terms, wp_term_relationships and wp_term_taxonomy – see the codex article on Database Description for more details. The parent relationship is part of the wp_term_taxonomy table, so you should inspect the differences between your environments in this table. wp_terms does not store such parent relationship information, so it’s no surprise that copying it didn’t change anything for you.
Related Posts:
- Is There a Difference Between Taxonomies and Categories?
- Check if a post is in any child category of a parent category
- How to export and import taxonomies (category, tag and/or custom taxonomy) and their terms
- get_categories for custom post type with a specific custom taxonomy attached
- Control term order on a per-post basis
- Could not insert term into the database
- How can I add the featured image functionality to a custom taxonomy?
- Share one taxonomy across multiple blogs in 3.0 [duplicate]
- Weird behaviour when adding terms/term_taxonomies programmatically
- wp_update_nav_menu_item() to insert categories
- Admin Panel – Disable Moving Selected Terms To Top of Metabox
- How to make custom taxonomy check boxes like ‘Categories’
- How to create non-unique sub-category slugs?
- How to get next previous category in same taxonomy?
- Display only deepest category on a single post?
- How to add HTML5 ‘required’ attribute to wp_dropdown_categories() without JavaScripts?
- Wrap a chosen category name with div
- What’s the difference between “parent” and “category_parent” in a WP_Term object?
- Update taxonomy value of post type in query
- How Do I Merge Categories With phpMyAdmin
- How to query posts from specific authors and categories using WP_query?
- Add custom taxonomy under the category title
- Display name of the last child category
- “Reversable” and “Re-useable” Subcategories (or other taxonomic structure)
- how to remove category from database
- List Terms in Category
- How to get category URL with the slug?
- How to view WordPress’ default category IDs?
- Random taxonomy category list
- Display Slug instead of Name
- Force a user’s posts category
- ACF: Display category name using taxonomy field
- Show Available Taxonomy List with Current Category
- Exclude a category from the_category in the single post page
- Taxonomy name repeating when showing 2 posts from each category
- Why does the argument list_only do on Walker_Category_Checklist::start_el?
- New Categories Not Shown In the Post Edit Page
- Shortcodes not working in category or tag description
- Filtering multiple categories via the URL
- Display specific categories by ID
- Display Posts Loop for each parent and for each Child
- Flat category URLs but retaining hierarchy?
- Drop posts from categories in MySql
- Customize category page for different custom taxonomies
- Get posts under a category with SQL
- How many categories can WordPress handle before performance suffers?
- Custom taxonomy template for categories
- Question on using custom structures for categories
- Array: What is this value based on?
- Display sibling categories on category page
- How to modify the output of wp_terms_checklist when used within the built-in category metabox on edit posts?
- WP REST API not retrieving all categories
- Some categories missing on wp-admin/edit-tags.php?taxonomy=category
- List just subcategory and products of active category page in Woocommerce
- WP 4.7 in_category change?
- Illegal string offset ‘taxonomy’ in
- Deleting a category from WordPress admin does it remove it completely from the database?
- How to schedule categories?
- How Do I Delete WordPress Posts Older Than 400 Days, From A WordPress Category
- Let user select their own category
- Copy post taxonomy?
- How to store category and tags separatly on wordpress?
- Setting selected term_id with wp_dropdown_categories?
- creating categories programmatically
- Combining these queries? (Same taxonomy term + same category as post)
- sidebar troubles, taxonomy trouble
- Category post count is not correct
- Disable Category Taxonomy
- WordPress Default Category and Custom Taxonomy Selected Attribute not Working After Searched in wp_dropdown_categories Array
- How can i change sort category view starting from child then parent, not alphabetically
- Filtering posts in category by tag URL
- Bulk assign posts to a category using SQL (MySQL)
- Image Upload Custom Form Field for Category and Custom Taxonomy
- outputting taxonomy hierarchy
- Search Replace Database ONLY for posts of certain category?
- Confused about category.php template – not working
- Filter custom taxonomy posts via AJAX
- Why use hierarchical taxonomies instead of many custom taxonomies?
- How get all media from a posts category by db?
- How to Manage and link certain custom taxonomy?
- Display Taxonomies in loop with template args
- Grouping parent categories into sections
- get_adjacent_post_link excluded_terms ignored
- Match two taxonomies to display a specific content
- Taxonomy for custom post type not found
- Category base 404 – fix
- Display only the latest post
- Return selected categories only in custom page meta box?
- get IDs from links categories
- Multiple Parent Category URLs
- Chained drop-down menu for custom taxonomy using chained.js
- Display only one level subcategory in wordpress
- Converting Categories (with ACF fields) to custom taxonomies
- Woocommerce custom taxonomy order
- Hook action when create new category [duplicate]
- Taxonomy term RestApi data 10 rows limitions
- Images as Categories
- hide_empty property not working when using get_terms
- Add custom fields to Woocommerce Category Page
- Quick Edit on taxonomy names results in error