MySql export types

  • halinagold

    (@halinagold)


    19 years, 11 months ago

    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

    (@michaelh)

    19 years, 11 months ago

    This should have the information you need:
    http://codex.ww.wp.xz.cn/Backing_Up_Your_Database

    Thread Starter halinagold

    (@halinagold)

    19 years, 11 months ago

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

    Thread Starter halinagold

    (@halinagold)

    19 years, 11 months 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).

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

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