WordPress.org

1. cyberquill
   Member
   Posted 2 years ago #

   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?

2. MichaelH
   Volunteer
   Posted 2 years ago #

   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

3. ymf
   Member
   Posted 2 years ago #

   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!

Topic Closed

This topic has been closed to new replies.