Title: Partial SQL database restore
Last modified: August 19, 2016

---

# Partial SQL database restore

 *  [angliss](https://wordpress.org/support/users/angliss/)
 * (@angliss)
 * [16 years, 5 months ago](https://wordpress.org/support/topic/partial-sql-database-restore/)
 * 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](https://wordpress.org/support/users/whooami/)
 * (@whooami)
 * [16 years, 5 months ago](https://wordpress.org/support/topic/partial-sql-database-restore/#post-1251961)
 * 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](https://wordpress.org/support/users/angliss/)
 * (@angliss)
 * [16 years, 5 months ago](https://wordpress.org/support/topic/partial-sql-database-restore/#post-1252044)
 * 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.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [angliss](https://wordpress.org/support/users/angliss/)
 * Last activity: [16 years, 5 months ago](https://wordpress.org/support/topic/partial-sql-database-restore/#post-1252044)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics