[wp-hackers] resetting post IDs

Kevin Newman CaptainN at unFocus.com
Wed Mar 16 00:40:24 UTC 2011

Looks like term_relationships->object_id will need to be updated too.

Kevin N.

On 3/15/11 5:52 PM, Kevin Newman wrote:
> Hello,
> I'm trying to manually mix two installs of Wordpress with two sets of 
> posts that have overlapping IDs.
> I'm comfortable updating the IDs in the necessary places - the 
> question is, what are those places?
> So far, the easy ones are:
> posts->ID
> postmeta->post_id
> comments->comment_post_ID
> Additionally, it looks like some of the object_id values may need to 
> be updated in the various terms and taxonomy tables.
> Anyone know for sure?
> Using the import/export feature simply didn't work, and I didn't try 
> the various plugins. I'm trying to retain the IDs of the larger data 
> set (which is what I'm importing to the smaller one) - because they 
> are using a permalink structure in an existing site that relies on 
> that data (at least I think it does - /archives/post_id? - I'll need 
> to check on that).
> Thanks,
> Kevin N.
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers

More information about the wp-hackers mailing list