This FAQ is designed to cover a recent development that we are seeing during the upgrade process. If the SimpleRisk installation and apache are on a separate server from the database such as an AWS RDS then it opens the possibility that the MySQL client is not the same version of MySQL on the RDS. When this happens it can cause the backup function to form the mysqldump command based on the server version of MySQL while the client MySQL that sends it will not interpret the command properly.

Symptom

Systems are unable to upgrade due to backup failure. Apache log will contain the following:
mysqldump: [ERROR] unknown variable ‘column-statistics=0’

 The Fix

To resolve this issue we need to update the mysql client to the same version as the RDS. In most cases we are seeing the client at 5.7 while the server is 8.0.2. You will need terminal access on the client machine running apache to make the changes necessary. Run the following from terminal:

wget https://dev.mysql.com/get/mysql-apt-config_0.8.22-1_all.deb

dpkg -i mysql-apt-config_0.8.22-1_all.deb

apt update

apt install mysql-client

Once these have been installed you may need to restart apache/mysql with:

systemctl restart mysql
systemctl restart apache2

This concludes this FAQ. If you require assistance with this issue on another operating system please let us know and we can attempt to help. Contact us at support@simplerisk.com for further assistance.