Title: Database backup uses wrong values for NULL
Last modified: December 3, 2018

---

# Database backup uses wrong values for NULL

 *  [SimonGiddings](https://wordpress.org/support/users/simongiddings/)
 * (@simongiddings)
 * [7 years, 6 months ago](https://wordpress.org/support/topic/database-backup-uses-wrong-values-for-null/)
 * I have just done a database backup on my production site and am trying to restore
   it on my dev system.
    However, when I run the sql script it keeps falling over
   with messages like
    - incorrect value “” for datetime
    - incorrect integer value ” for column x
 * I am using version 6.0.0 of iThemese Security.
 * Is this a known problem ?
    Is there a corrective fix or workaround possible ?

Viewing 1 replies (of 1 total)

 *  [nlpro](https://wordpress.org/support/users/nlpro/)
 * (@nlpro)
 * [7 years, 6 months ago](https://wordpress.org/support/topic/database-backup-uses-wrong-values-for-null/#post-10942820)
 * Why not update to the latest iTSEc plugin release (7.2.0) and test ?
 * The 6.0.0 release is 2 years old …
 * I’m not saying the 7.2.0 release will fix this particular issue, but there have
   been several important improvements in the database backup code…
 * Just search for the word “backup” in the plugin Changelog history and you’ll 
   find 8 database backup fixes since 6.0.0 …
 * One other thing, what are the from and to MySQL versions ?
    It could be a MySQL
   version incompatibility issue (or sql_mode).
    -  This reply was modified 7 years, 6 months ago by [nlpro](https://wordpress.org/support/users/nlpro/).
    -  This reply was modified 7 years, 6 months ago by [nlpro](https://wordpress.org/support/users/nlpro/).

Viewing 1 replies (of 1 total)

The topic ‘Database backup uses wrong values for NULL’ is closed to new replies.

 * ![](https://ps.w.org/better-wp-security/assets/icon.svg?rev=3529351)
 * [Kadence Security – Password, Two Factor Authentication, and Brute Force Protection](https://wordpress.org/plugins/better-wp-security/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/better-wp-security/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/better-wp-security/)
 * [Active Topics](https://wordpress.org/support/plugin/better-wp-security/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/better-wp-security/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/better-wp-security/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [nlpro](https://wordpress.org/support/users/nlpro/)
 * Last activity: [7 years, 6 months ago](https://wordpress.org/support/topic/database-backup-uses-wrong-values-for-null/#post-10942820)
 * Status: not resolved