WordPress.org

Support

Support » How-To and Troubleshooting » [Resolved] Backing up WP MySQL databse with phpMyAdmin — which boxes to check?

[Resolved] Backing up WP MySQL databse with phpMyAdmin — which boxes to check?

  • I would like to back up my WP database, but I found two different versions regarding which boxes to check in phpMyAdmin.

    Version #1:
    http://www.cyberquill.com/sql.jpg

    Box “Add IF NOT EXISTS” is UNchecked, but “Complete Inserts” and “Use hexadecimal for binary fields” are checked. (Source: http://codex.wordpress.org/WordPress_Backups)

    Version #2:
    http://www.cyberquill.com/sql2.jpg

    Here, box “Add IF NOT EXISTS” is checked, but “Complete Inserts” and “Use hexadecimal for BLOB” are UNchecked. (Source: http://codex.wordpress.org/Backing_Up_Your_Database)

    I don’t really know what all these boxes mean, and so I don’t know if it matters, but still I’d like to know which of these three should be checked so as to prevent problems when restoring the database, should it ever crash:

    • Add IF NOT EXISTS
    • Complete Inserts
    • Use hexadecimal for binary fields

    Which of these three boxes should be checked?

Viewing 2 replies - 1 through 2 (of 2 total)
  • http://www.phpmyadmin.net/documentation/

    “If Not Exists” will only create the table if it doesn’t exist. Otherwise, you may get an error if the table name exists but has a different structure. Meaning it won’t overwrite an exisiting file on restore
    “Complete inserts” adds the column names on every INSERT command, for better documentation (but resulting file is bigger).
    “Extended inserts” provides a shorter dump file by using only once the INSERT verb and the table name.

    As for the “Use hexadecimal for binary fields” it probably doesn’t matter what you check as WordPress doesn’t use any binary fields. If you have a plugin that has that field type I would check that field.

    http://wordpress.org/support/topic/323246?replies=4
    http://wordpress.org/support/topic/323004?replies=10

    I’m glad I found this topic — just was going to ask this same question. It would be nice if somebody knowledgeable could synchronize these two versions of documentation on codex. Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[Resolved] Backing up WP MySQL databse with phpMyAdmin — which boxes to check?’ is closed to new replies.
Skip to toolbar