Auto backup using mysqldump not working.

[Kailasam Nagaraju]

After upgrading from 8.0.18 to 8.0.20 we had to manually set binary-as-hex to false in the /etc/my.cnf file for AES_Encryption and decryption as follows to function properly. Below is the addition that we did.

[client]
binary-as-hex = false

[mysql]
binary-as-hex = false

After doing the above, we now observe that our auto backups using mysqldump have started erroring out with the below error message. Sharing the script that we are using for our auto backups below:

mysqldump --defaults-extra-file=/root/.my.cnf -u ${MYSQL_USER} \
${DATABASE_NAME} | gzip > ${DB_BACKUP_PATH}/${TODAY}/${DATABASE_NAME}-${TODAY}.sql.gz

This functionality used to occur daily using mysqldump before the above change was made and was working as expected.

mysqldump: [ERROR] unknown variable 'binary-as-hex=false'

Kindly assist. How do I get the auto backups working again ?