Title: MySql export types
Last modified: August 18, 2016

---

# MySql export types

 *  [halinagold](https://wordpress.org/support/users/halinagold/)
 * (@halinagold)
 * [19 years, 11 months ago](https://wordpress.org/support/topic/mysql-export-types/)
 * Hi
 * I want to make a backup of the MySql database using PhpMyAdmin. I am given the
   choice between 3 export types: INSERT, UPDATE, REPLACE. I have no idea what they
   mean and which one to choose. What would you recommend?
    ( As you probably have
   guessed I know close to nothing about PHP / MySQL…)
 * Thanks –
 * Halina – Denmark

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

 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [19 years, 11 months ago](https://wordpress.org/support/topic/mysql-export-types/#post-413314)
 * This should have the information you need:
    [http://codex.wordpress.org/Backing_Up_Your_Database](http://codex.wordpress.org/Backing_Up_Your_Database)
 *  Thread Starter [halinagold](https://wordpress.org/support/users/halinagold/)
 * (@halinagold)
 * [19 years, 11 months ago](https://wordpress.org/support/topic/mysql-export-types/#post-413407)
 * I’ve read the chapter on Using phpMyAdmin however it does not mention anything
   about export types nor what they mean… :-((
 *  Thread Starter [halinagold](https://wordpress.org/support/users/halinagold/)
 * (@halinagold)
 * [19 years, 11 months ago](https://wordpress.org/support/topic/mysql-export-types/#post-413438)
 * I just received an explanation from my Danish host provider. I include it here,
   in case anyone else wants to know:
 * When you do an export, a sql script is being generated, to be used when recovering
   your database. Here’s how the 3 types work:
 * Insert: Inserts records from the exported file (regardless if they’re in the 
   database already or not).
 * Update: Updates those records that are in the database already. This means that
   if a field is empty it will be updates – if it’s not empty then it won’t be affected
   by the exported record.
 * Replace: Overwrites the records that are in the database, but does not insert
   records that have been deleted.
 * Insert is recommended in most cases (and is defaut too).

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

The topic ‘MySql export types’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [halinagold](https://wordpress.org/support/users/halinagold/)
 * Last activity: [19 years, 11 months ago](https://wordpress.org/support/topic/mysql-export-types/#post-413438)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics