Title: [Plugin: WP-DB-Backup] NULL, not '', for datetime column for .sql file
Last modified: August 20, 2016

---

# [Plugin: WP-DB-Backup] NULL, not '', for datetime column for .sql file

 *  [alexyoshida](https://wordpress.org/support/users/alexyoshida/)
 * (@alexyoshida)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wp-db-backup-null-not-for-datetime-column-for-sql-file/)
 * Recently, I tried to restore from the backup file and encountered lots of errors.
 * After examining the error message in MySQL workbench, I realized that the “datetime”
   column had the value ” in the backup’s insert line.
 * I am using Windows/MySQL 5.1 (5.1.3?) for Windows. I am not sure if this is the
   problem, but my MySQL requires NULL value for a datetime-type column. But, your
   plugin output ” for the datetime-type column. This causes the error when trying
   to restore the backup file (.sql) to MySQL.
 * Is there anyway you can fix this?
 * [http://wordpress.org/extend/plugins/wp-db-backup/](http://wordpress.org/extend/plugins/wp-db-backup/)

The topic ‘[Plugin: WP-DB-Backup] NULL, not '', for datetime column for .sql file’
is closed to new replies.

 * ![](https://ps.w.org/wp-db-backup/assets/icon.svg?rev=2645691)
 * [Database Backup for WordPress](https://wordpress.org/plugins/wp-db-backup/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-db-backup/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-db-backup/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-db-backup/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-db-backup/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-db-backup/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [alexyoshida](https://wordpress.org/support/users/alexyoshida/)
 * Last activity: [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-wp-db-backup-null-not-for-datetime-column-for-sql-file/)
 * Status: not resolved