Symptoms
- Plesk upgrade fails with:
/usr/bin/mysqldump: unknown variable 'bind-address=203.0.113.2'
ERROR while trying to backup MySQL database -
Unable to create a backup of all databases with the following command:
# MYSQL_PWD=cat /etc/psa/.psa.shadow mysqldump -u admin –all-databases –routines –triggers > /tmp/all-databases.sql
mysqldump: unknown variable ‘datadir=/var/lib/mysql’
mysqldump: unknown variable `symbolic-links=0` - There are some parameters underÂ
[mysqldump]
section un-commented inÂ/etc/my.cnf
:# cat /etc/my.cnf
…
[mysqldump]
symbolic-links=0
Cause
An incorrect variable in the MySQL/MariaDB configuration file.
Resolution
-
Connect to the server via SSH.
- Create a backup copy of my.cnf file:
# cp /etc/my.cnf /etc/my.cnf.bak
-
Open
/etc/my.cnf
file for editing. -
Comment all line inÂ
[mysqldump]
section, including [mysqldump] itself:#[mysqldump]
#symbolic-links=0 -
Restart MySQL service
# service mariadb restart