Error while backing up database

[nasha]

Hi,
I want to use "admin back up" to back up all users but it can't back up mysql DB.

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

How can I fix it

 

[zEitEr]

Hello,

Update /etc/my.cnf or files under /etc/my.cnf.d/ and remove

[COLOR=#333333]local-infile=0

from section [mysqldump][/COLOR]

 

[nasha]

Thanks zEitEr,
But I inserted this line cause CSf recommended. What do you suggest for security reasons.

 

[zEitEr]

You inserted the line into the wrong section. You should add it into the correct place.

 

[nasha]

Shall I follow
https://help.directadmin.com/item.php?id=208

 

[nasha]

I can't find this path "/etc/mysql/my.cnf", then where shall I insert it.

 

[SeLLeRoNe]

The guide you posted say the file and his path.

Best regards

 

[zEitEr]

Shall I follow
https://help.directadmin.com/item.php?id=208

The guide is fine. Create the file if it's missing and restart mysql/mariadb.