Partial SQL database restore

  • angliss

    (@angliss)


    16 years, 5 months ago

    A couple of months ago, a former user at my site got POed and deleted all his posts before leaving. I didn’t notice it until a couple of weeks ago. I have a backup of the database that contains the vast majority of his posts, but I don’t want to just restore it directly because it would overwrite all the stuff that’s been pulled since.

    Is there a way to re-import just his stuff from SQL without messing with everything else?

    Thanks.

Viewing 2 replies - 1 through 2 (of 2 total)
  • whooami

    (@whooami)

    16 years, 5 months ago

    why do you think something that is older is going to overwrite something thats newer?

    is this not the same database? if it is, overwrites arent the concern. wordpress doesnt reuse IDs .. Instead, what you need to be concerned with is that insert queries are compatible with whatever upgrades, if any, youve done since the backup was taken.

    beware the copyright police.

    Thread Starter angliss

    (@angliss)

    16 years, 5 months ago

    Because I’ve only tried to reimport via phpMyAdmin, instead of the import tool. I’ve needed to go that route because my SQL database is 200 Meg, and the last time I tried to import it via the WP tool, it crashed.

    Now, that was 2 years ago, so maybe it’ll work better this time.

    As for updating the database, I have a development environment that I can download the latest WP into, install the old database, upgrade it, and then extract and upload the correct version.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Partial SQL database restore’ is closed to new replies.