Title: Joining two overlapping databases
Last modified: August 18, 2016

---

# Joining two overlapping databases

 *  [lastt](https://wordpress.org/support/users/lastt/)
 * (@lastt)
 * [20 years, 5 months ago](https://wordpress.org/support/topic/joining-two-overlapping-databases/)
 * Hello,
    I had a user deleted and would like to put all of that user’s data back
   in from a mysql dump I have from the night before that happened. The problem 
   is that there are a lot of duplicate entries in the old sql dump and the current
   database. Is there a way to ask it to put them in but to ignore or overwrite 
   duplicate entries? As it is, I get a table already exists error when executing:`
   mysql -u username -p dbname > old_backup.sql`
 * Thanks in advance!

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

 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [20 years, 5 months ago](https://wordpress.org/support/topic/joining-two-overlapping-databases/#post-295969)
 * If I were doing this with [phpMyAdmin](http://codex.wordpress.org/phpMyAdmin)
   I’d DROP all the tables in your current database before [Restoring your database](http://codex.wordpress.org/Restoring_Your_Database_From_Backup).
 * Additional Info: [Database_Description](http://codex.wordpress.org/Database_Description)
 * ********************
    Welcome to the WordPress Support Forums!
 * Please help keep the Forums successful by reading:
    [Using the Support Forums](http://codex.wordpress.org/Using_the_Support_Forums)
 * Also, remember the [WordPress Codex](http://codex.wordpress.org/Main_Page) and
   the [FAQ pages](http://codex.wordpress.org/FAQ).
 * And, thank you, for letting us know if this information proves useful (or not)!
   ********************
 *  Thread Starter [lastt](https://wordpress.org/support/users/lastt/)
 * (@lastt)
 * [20 years, 5 months ago](https://wordpress.org/support/topic/joining-two-overlapping-databases/#post-295987)
 * Thanks but if I drop it i can only put one sql dump’s info back in.
 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [20 years, 5 months ago](https://wordpress.org/support/topic/joining-two-overlapping-databases/#post-296004)
 * When I [backup my database](http://codex.wordpress.org/Backing_Up_Your_Database)
   all tables get backed up so if a restore is necessary I can restore all tables.
 *  Thread Starter [lastt](https://wordpress.org/support/users/lastt/)
 * (@lastt)
 * [20 years, 5 months ago](https://wordpress.org/support/topic/joining-two-overlapping-databases/#post-296384)
 * Same here but I have the problem of overlapping duplicate entries. Thanks!

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

The topic ‘Joining two overlapping databases’ is closed to new replies.

## Tags

 * [dump](https://wordpress.org/support/topic-tag/dump/)
 * [Merge](https://wordpress.org/support/topic-tag/merge/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 2 participants
 * Last reply from: [lastt](https://wordpress.org/support/users/lastt/)
 * Last activity: [20 years, 5 months ago](https://wordpress.org/support/topic/joining-two-overlapping-databases/#post-296384)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics