• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

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

makenext.srl

New Pleskian
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
 
Back
Top