Backup Fail unknown variable column-statistics

Hi i get this error when trying to backup a db. Any ideas

5/31/2019 3:03:38 PM [Error] Failed to backup “clubmaster” database with “Full” backup type: #[DBMS-MSSQL:11006#11007] mysqldump: unknown variable ‘column-statistics=0’

Hello Johannes_Nortje,

To resolve this issue please go to the “MySQL Backup Options” and set “Generate statistics histograms” to “Default” if it doesn’t help please try to set to “No”. It should resolve the issue.

1 Like

Worked for me - thank you :slight_smile:

1 Like

Good news! Please feel free to contact us on any issues or concerns.

I don’t see this “Output SQL file options” window anywhere in SQLBackupAndFTP 12.2.11 Professional.

Hi Jireh_Semiconductor,

Could you please clarify your question?

Could you please make sure that you set the connection to your MySQL Server (TCP/IP)?

Sorry for the inconvenience.