Extended inserts option in SQL file

  • Resolved heatherlander

    (@heatherlander)


    9 years ago

    Our database is large, and cannot be restored using PhpMyAdmin. So instead we use BigDump to load backed up sql files. However, BigDump cannot handle excessively long query lines, so it does not work if the “extended inserts” option is used when creating the backup sql file. Is there an option to not use extended inserts with the BackWPup plugin?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter heatherlander

    (@heatherlander)

    9 years ago

    Further to the above, the issue seems to be due to each insert query being spread across many lines. A similar export from the database with extended inserts but without the line breaks between table rows does not have the same problem.

    Plugin Contributor Brandon Olivares

    (@cocreation)

    8 years, 11 months ago

    Hi @heatherlander. Thanks for the suggestion. We will include this in an upcoming version.

    I’m going to mark this as resolved, but if you need anything else, feel free to let us know.

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

The topic ‘Extended inserts option in SQL file’ is closed to new replies.