Backup fails

[Remco00]

New installed DA Centos 7 server. However backup fails with:

Error while backing up database test_wp1
Error while backing up database testl_wp1: The sql file is 0 bytes in size: /home/admin/user_backups/test/backup/test_wp1.sql
mysqldump error output: /usr/bin/mysqldump: unknown variable 'local-infile=0'

Error Compressing the backup file /home/admin/user_backups/test/backup/home.tar.gz : /bin/tar: .pki: Cannot open: Permission denied
/bin/tar: Exiting with failure status due to previous errors

There is no root/.my.cnf files as I read in other threats as possible sollution. File /usr/local/directadmin/conf/my.cnf contains proper user da_admin and password.

 

[zEitEr]

Hello,

That's core:

unknown variable 'local-infile=0'

You should remove it from /etc/my.cnf or wherever else you use it.

 

[Remco00]

Thanks, I indeed checked the file /etc/my.cnf. This is how it looked after default installation and running CB2.0 updates:

#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

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

local-infile=0

After changing the last two lines into:

[mysqld]
local-infile=0

the backup was running fine with no errors.