I am looking for an easy way to create the same categories with the same ids across all the blogs on a word-press multi site install. Is there an easy way to do this? I am not very good my mysql but i am sure there is some way to get it to do it. Any help would be greatly appreciated. I tried just updating the terms table and the categories didn't show up on the blogs.
Yeah WP-cloner doesn't look like it will get the job done. I need to do this for 20 sites and they all need the same categories with ids and descriptions on them. I dont want to have to go install the plugin on 20 sites and then set the settings for each one.
I took a quick look at the database schema (structure) and it looks like there are four tables involved in the relationships: 1) posts 2) term_taxonomy 3) term_relationships 4) terms The posts table contains the blogs. It is related to categories (and other terms) by joining the post table with the term_relationships table and the term_taxonomy table. This is then joined with the terms table to pick up the name of the term. The technical term for this structure is "overloading" because Wordpress mixes all kinds of terms (e.g. tags, categories) in the same table. It is an awful design which causes all kinds of performance and maintainability issues and was clearly designed by inexperienced database designers who thought loading all the terms in one table would be cute. They should have just created separate tables for each term. It would have been very clean, easy to understand, and easy to maintain, and smaller tables with much better performance - just a few more tables, but who cares. Well, c'est la vie. Rich
WPMUDEV has a blog template plug in that allows you to set categories, and settings for all new blogs on the network so that they are universal: http://premium.wpmudev.org/project/new-blog-template