I would like to back up my WP database, but I found two different versions regarding which boxes to check in phpMyAdmin.
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)
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?