MySQL incremental backup failed

Application issues
1

Hi, I got an error when I try to doing incremental backup on MariaDB 10.5.x or MySQL 5.7.
The error message is saying could not found table information_schema.COLUMN_STATISTICS

I checked information_schema, there is no table COLUMN_STATISTICS.
I found this table will exists in MySQL 8.0 but not exists in older version of MySQL/MariaDB.

Is there any way to fix this error ?

By the way, MySQL is running on Centos7, but SQLBackupAndFtp is running on Windows, I don’t have MySQL bin folder on Windows.
Set Generate Statistics Histograms to NO/DEFAULT doesn’t work for me.

Thanks.

2

Hello Jeff,

Incremental backups are only available for local connections. We recommend trying our alternative backup solution, SqlBak, which has a Linux version available. To use it, please install SqlBak on the same server where MySQL Server is installed and ensure that the bin logs are enabled. You can find more details here:
https://sqlbak.com/blog/incremental-mysql-server-backup-via-binary-log/
https://sqlbak.com/blog/about-mysql-server-incremental-backups-in-sqlbak/

If you have any other questions, please let us know.

Thank you, and we apologize for any inconvenience.