NULL, not '', for datetime column for .sql file (1 post)

  1. alexyoshida
    Posted 3 years ago #

    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?


Topic Closed

This topic has been closed to new replies.

About this Plugin

  • WP-DB-Backup
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic


No tags yet.