[wp-hackers] resetting post IDs

Kevin Newman CaptainN at unFocus.com
Wed Mar 16 20:37:07 UTC 2011


I almost missed post_parent - luckily, Wordpress complained. :-)

I think I'm clear on the thumbnails - there are none in use.

Thanks for help!

Kevin N.


On 3/15/2011 9:52 PM, Casey Bisson wrote:
> And, if you're using featured images/post thumbnails, the postmeta on the post that points to the thumbnail's post id needs to be updated (sorry I can't recall the meta key).
>
> You might consider, instead, doing this via the wp export and import. That will update post IDs as it goes.
>
> --Casey Bisson
>
> http://MaisonBisson.com
>
> On Mar 15, 2011, at 5:55 PM, Louis McCoy<louie at louiemccoy.com>  wrote:
>
>> 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.
>>>>



More information about the wp-hackers mailing list