MySQL database backup failed with error Unknown table 'COLUMN_STATISTICS' in information schema (1109). MySQL database does not have the “COLUMN STATISTICS table under information schema and back up fails.

This issue can be fixed by making below entry in MySQL ZRM configuration file. The configuration file is located in /etc/mysql-zrm/<backupset name>

• Edit the configuration file

#vim /etc/mysql-zrm/<backupset name>/mysql-zrm.conf

• Append the below line at the end of the file.
column-statistics=0

• Save the file and proceed with the testing the backup again.

Note: The md5sum of the file /opt/zmanda/zrm/mysql/my.cnf should be ff6dbce0545bde8a5378f14e6f7ad386

************************************************** ************************************************** ******************
Please follow the above steps to fixe the issue. In case if you need any assistance, kindly contact support.
support can be reached @ [email protected]
Or call us @ 888-496-2632 (U.S.)/ 408-732-3208 (INTL)