MySQL backup

  • stoarcecreierul

    (@stoarcecreierul)


    16 years ago

    Exporting the database through phpMyAdmin for backup purpose or moving to another host/domain offers some options.

    Other software I’m using (a phpBB forum sharing the database with WP) sugests that I uncheck Extended Inserts in the Data section.

    How is that affecting the transfer of WordPress tables ? For a correct backup should that be checked or unchecked ?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    16 years ago

    A quick of the phpMyAdmin docs says:

    “extended inserts” provides a shorter dump file by using only once the INSERT verb and the table name.

    I don’t think any harm will come from unchecking. FWIW, I’ve backed up a gazillion times and I always leave that checked. I wonder why phpBB says not to.

    Moderator James Huff

    (@macmanx)

    16 years ago

    According to our detailed instructions for backing up via phpMyAdmin, “Extended inserts” should be unchecked anyway.

    mrmist

    (@mrmist)

    16 years ago

    It shouldn’t matter either way. Go with whatever makes you happy.

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

The topic ‘MySQL backup’ is closed to new replies.