MySQL Forums
Forum List  »  Backup

Auto backup using mysqldump not working.
Posted by: Kailasam Nagaraju
Date: December 15, 2020 10:09PM

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 ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Auto backup using mysqldump not working.
808
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.