This bug has created a serious problem for me. Because DATETIME values in general are not quoted in database backups created by BackUpWordPress, I cannot import my database from a backup using phpMyAdmin. I get an error message that complains of bad syntax (i.e., missing delimiters).
The MySQL database dumps I created using cPanel on my hosting account, the Duplicator plugin on my live site, and the DesktopServer Premium development environment on my local machine all enclose DATETIME values in delimiters. I’ve had no trouble importing my database when DATETIME values are quoted.
Lack of delimiters around DATETIME values renders the database backup useless to me. I may now have to find a new backup plugin, which would be a shame, because I really like BackUpWordPress!
I mistakenly assumed that datetime and timestamp values were treated the same way by this plugin, but that’s not the case. I just double-checked a database backup which I created with this plugin, and datetime values are enclosed in quotes. It’s timestamp values which are not enclosed in quotes, like the original post said.