Resolved Failed to execute backup database: unknown variable 'bind-address=127.0.0.1'

[makenext.srl]

Hello,
my name i Marco Adreani.
We have a CentOS 7 server with Plesk Onyx 17.8.11 and MariaDB 5.5.68.
Recently nightly scheduled backups fail to backup every databases on the server with the following error:

Warning: mysql "cbtdbtpad_db"
Failed to execute backup database

Warning: mysql "cbtdbtpad_db"
Not all the data was backed up into /var/lib/psa/dumps/clients/cbtdbtpad/domains/cbtdbtpadova.it/databases/cbtdbtpad_db_1 successfully. Total space: 1687.00 GB; Available space: 514.00 GB; Mounted on: /var. /usr/bin/mysqldump: unknown variable 'bind-address=127.0.0.1'

The configuration file /etc/my.cnf is:

max_allowed_packet=4096M
[mysqldump]
max_allowed_packet=4096M
bind-address=127.0.0.1
#bind-address = ::ffff:127.0.0.1
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in Understanding and administering systemd :: Fedora Docs

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

We cannot find any reference on the web about it.
Someone can help us solving this issue?
Thank you in advance
Marco Adreani
Make Next Srl

 

[IgorG]

https://support.plesk.com/hc/en-us/articles/360007978213-Plesk-upgrade-or-databases-backup-fails-mysqldump-unknown-variable

 

[makenext.srl]

Hi IgorG,
we followed your suggestion and solved it!
Thank you very much!
Marco Adreani