ERROR 1616 (HY000) at line 97: DELAYED option not supported for table ‘address’
I get this error message when I try to import into MySQL. I am using the latest version of SQLBackUpAndFtp. It used to work with previous versions, but not any longer.
Obviously the SQL being generated contains DELAYED INSERT statements that are not supported by MySQL any longer due to deprecation! As far as I understand they have been ignored by the last couple of MySQL versions but produce an error in more recent versions. Here is a link: https://dba.stackexchange.com/questions/160168/mysql-insert-delayed-deprecated-what-now
I have a preliminary solution for this: I edited the generated .sql file and deleted all DELAYED statements from it. Then it worked. Obviously the DELAYED statement is not only deprecated it seems to be completely useless, too.
Can you guys fix this bug please.