[wp-hackers] resetting post IDs

Louis McCoy louie at louiemccoy.com
Wed Mar 16 00:55:05 UTC 2011


Don't forget about posts->post_parent for revisions.

I think you've nailed all of them.

---
Louie McCoy
Well & Lighthouse


On Tue, Mar 15, 2011 at 8:40 PM, Kevin Newman <CaptainN at unfocus.com> wrote:

> 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
>>
>
> _______________________________________________
> 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