How to transfer categories (default) to custom taxonomy?

wp links the posts and the terms in table wp_term_relationships so one doesn’t really have to worry about the custom taxonomy. You basically want to change the term ids from that of the default to the term_id of the new term in your custom taxonomy for your select set of posts. Lookup the term_ids and then do

UPDATE wp_term_relationships SET  term_taxonomy_id = 'newterm_id' 
WHERE term_taxonomy_id = 'oldterm_id' AND object_id IN 
(SELECT ID FROM wp_posts WHERE post_type="movies")

Related Posts:

  1. How to get all taxonomies of a post type?
  2. Saving Taxonomy Terms
  3. Get Posts by Custom Post Type ,Taxonomy, and Term
  4. How do I append multiple taxonomies to the URL?
  5. Custom Taxonomy’s Label to change the text appearing in Appearance > Menu
  6. How to completely disable a taxonomy archive on the frontend?
  7. How to limit the number of terms (terms acts like categories)
  8. How can I list all the categories under a Custom Post Type (taxonomy)?
  9. How do I list custom taxonomy terms without the links?
  10. How to list custom taxonomy categories?
  11. Custom Taxonomy Template Post List with Sort Order
  12. wp_insert_term doesn’t work with custom post type’s taxonomy
  13. Taxonomy archives based on Custom Post Type
  14. Get the ‘slug’ of a custom taxonomy
  15. Custom Metabox with Taxonomy Dropdown – Saving Issue
  16. How to show term-specific post list, without posts associated with child terms?
  17. How to get the parent’s taxonomy?
  18. Include custom post type in “all posts”
  19. wp_insert_post custom taxonomy
  20. Display taxonomy term only if there’s a value
  21. Get all taxonomies for all post types
  22. Custom post type taxonomy template
  23. Is slug “type” reserved and can’t be used in taxonomy rewrite?
  24. Remove Taxonomy Slug when No Taxonomy is Assigned to Custom Post Type?
  25. Taxonomy Templates
  26. Problem with custom post types, taxonomy and permalinks
  27. How to create new category for custom post type?
  28. Fetch taxonomies by custom post type id array
  29. get_terms showing all categories instead of the ones assigned to a specific post
  30. Query Multiple Taxominies Across Multiple Post type’s
  31. wp_set_object_terms() not adding new term to custom post and custom taxonomy
  32. Categories of custom taxonomy don’t show any posts
  33. Custom Taxonomy back-end customizations
  34. Taxonomy custom post type URL
  35. Is it possible to have dedicated page for parent/child taxonomy?
  36. Display a grid of taxonomy terms at root taxonomy page
  37. limit value taxonomy based on previous taxonomy value wordpress
  38. How do I display the taxonomy for a custom post type in an array
  39. How to conditionally redirect to the post from a taxonomy page?
  40. How do I check if the user is on a taxonomy term parent, child or grandchild page?
  41. Suggested Post and Taxonomy structure
  42. Custom post with more than one custom taxonomy
  43. Get the taxonomy of a post hierarchically
  44. How to make custom taxonomy into drop down select in a custom metabox
  45. How do I share categories across multiple post types?
  46. Multiple tag cloud filtering
  47. Get url.com/post_type/taxonomy/term work!
  48. How to display products name in a non-alphabetical order, in a custom field (taxonomy)?
  49. Taxonomy in URL
  50. Custom Post Type Category Link
  51. Custom Post type category pages template and loop
  52. How to Set Taxonomy Object Description?
  53. Custom select query for taxonomies that have posts categorized in another taxonomy
  54. Custom Taxonomy Is Being Pulled into a Page, But It Doesn’t Have A Hyperlink
  55. Querying two taxonomies with tax_query not woking
  56. Variable not working in WP_Query
  57. Hide meta box for everything BUT a certain custom post type
  58. Alphabetically sort a taxonomy.php template by post title
  59. Custom Post Types not queried in Custom Taxonomy archives or Native archives
  60. Show Taxonomies with admin area for custom post type?
  61. Custom taxonomy template list not working (404)
  62. Use the custom post type archive for taxonomies?
  63. Taxonomy template page not working
  64. Changing CPT slug and taxonomy already registered in parent theme
  65. Copy/Move selected taxonomy terms to another taxonomy for posts
  66. Get posts by category name
  67. Query Custom Post Type by Taxonomy
  68. How can i display a taxonomy? i have created a plugin and then a custom type. and a taxonomy , also i have register it
  69. Define multiple prefixes for custom post type
  70. How to order taxonomy terms by most recent post?
  71. Custom taxonomy returns 404 even with saving permalinks
  72. Create custom post type categories
  73. Taxonomies are not showing in the category dropdown
  74. Change custom post taxonomy values from front-end
  75. Display 3 level taxonomies
  76. Set a Default CPT taxonomy by taxonomy id
  77. List all posts associated under custom taxonomy
  78. Custom Taxonomy – fields
  79. Pages of my taxonomy terms are showing all posts
  80. Custom post type category link + add to menu
  81. If custom taxonomy exist on post?
  82. Single taxonomy for different custom post types
  83. How to get all posts assigned to a taxonomy term only?
  84. How to show post which has the specific taxonomy terms?
  85. Best approach to allow front-end display of posts’ reviewers?
  86. WordPress add taxonomies/terms list as a menu in archive page
  87. Custom Post Type and Taxonomies, creating the corresponding template file and loop the data
  88. How to create TEMPLATES for TAXONOMIES? What I have to change in this code?
  89. Displaying taxonomy icon outside archive page
  90. Custom post type post taxonomies
  91. Archive templates based on taxonomies
  92. Show taxonomies from specific CPT
  93. insert a taxonomy for a custom post type
  94. See the process of creating a taxonomy and tell me where I made a mistake
  95. Display associated taxonomy child name on single CPT page
  96. Issue On Listing Woocommerce Parent Tag List
  97. How to add to taxonomies to a post type
  98. Filtering custom post types using category taxonomy
  99. Taxonomy term archive claims there are no posts, but there are. How to resolve?
  100. How to list custom taxonomy terms without the hyperlinks?