MySql export types (4 posts)

  1. halinagold
    Posted 10 years ago #


    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

  2. MichaelH
    Posted 10 years ago #

    This should have the information you need:

  3. halinagold
    Posted 10 years ago #

    I've read the chapter on Using phpMyAdmin however it does not mention anything about export types nor what they mean... :-((

  4. halinagold
    Posted 10 years ago #

    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).

Topic Closed

This topic has been closed to new replies.

About this Topic