MySQL backup error: unknown variable ‘column-statistics=0’


The version of mysqldump utility used by SQLBackupAndFTP to create MySQL backup doesn’t support the –column-statistics parameter (it should be older than 8.0.2).

Hot to fix

Update mysqldump utility used by SQLBackupAndFTP.


Open the backup job settings and set the value of Generate Statistics Histograms parameter to Default if you don’t need to generate histogram statistics.