The following error message:
[DBMS-MSSQL:11006#11007] MySQL backup error: unknown variable ‘column-statistics=0’
means that 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
- Specify a path to your MySQL Server bin folder
- 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.
Hmm, I had this exception (Version 12.7.0 Pro), but ‘generate statistics histogram’ was set to false. And if I set this to true, the exception disappeared. I don’t really understand …
Hi Dave,
It depends on the version of MySQL Server you use. If the “true” value works for you, please use it.
Hi, this happens when I schedule incremental backups.
When I have the schedule set to full backups only it works. But the moment I enable incremental backups I get the error.
Hello Stephen,
Have you attempted to address the problem by following the suggestions outlined in the blog post?
Yes (and a variety of variations on the instructions). That is why I posted this.
Following the instructions in the post the full backup works. Incremental backups exhibit the same error/problem.
Just wondering if there is any more feedback on this. It is making the product less than ideal as we have to do full backups every time rather than incrementals.
Hi Stephen,
To conduct a more detailed investigation of the issue you are facing, could you please reach out to our support team at https://sqlbackupandftp.com/support?
Thank you for your cooperation, and we apologize for any inconvenience caused.
Hi
Was there a solution for this problem? I’m facing the same problem during the trial period.
Thank you!
Hello Michael,
It appears that you are attempting to perform incremental backups using a remote connection. Unfortunately, this is not possible. Kindly install SQLBackupAndFTP on the same server where your MySQL Server is installed.
Thank you!