Backup Fail unknown variable column-statistics

Johannes_Nortje · May 31, 2019, 1:13pm

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’

Alexander · June 3, 2019, 12:52pm

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.

dynamicsjon · July 5, 2019, 4:58am

Worked for me - thank you

Alexander · July 10, 2019, 7:18am

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

Jireh_Semiconductor · January 21, 2020, 6:27pm

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

Alexander · January 24, 2020, 3:01pm

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.