Auto backup using mysqldump not working.
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 ?
Subject
Views
Written By
Posted
Auto backup using mysqldump not working.
949
December 15, 2020 10:09PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.