Posted 1 month 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.
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.
Posted 1 month 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.
You must log in to post.
