Error found on the email from - Anacron job 'cron.daily'

[ring_c]

For the first time I've looked deeply into the email received for the daily backups and found some errors (marked the errors in Red):

---
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dba --> /backup/mysql/daily//dbb_dba.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbb --> /backup/mysql/daily//dbb_dbb.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbc --> /backup/mysql/daily//dbb_dbc.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbd --> /backup/mysql/daily//dbb_dbd.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbe --> /backup/mysql/daily//dbb_dbe.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbf --> /backup/mysql/daily//dbb_dbf.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbg --> /backup/mysql/daily//dbb_dbg.sql
Skipping database: information_schema.
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbh --> /backup/mysql/daily//dbb_dbh.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: mysql --> /backup/mysql/daily//mysql.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: oauthv2 --> /backup/mysql/daily//oauthv2.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: performance_schema --> /backup/mysql/daily//performance_schema.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: postfix --> /backup/mysql/daily//postfix.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: root_cwp --> /backup/mysql/daily//root_cwp.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: roundcube --> /backup/mysql/daily//roundcube.sql
mysqldump: unknown variable 'local-infile=0'
Database Backup: dbb_dbi --> /backup/mysql/daily//dbb_dbi.sql
warning: /var/tmp/rpm-tmp.RpBiRK: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEYerror: Failed dependencies:
       perl(DBD::mysql) >= 1.0 is needed by percona-toolkit-2.2.16-1.noarch
---

Any idea what might be wrong?

[bullten]

What is output of

Code Select Expand

cat /etc/my.cnf

Did you added local-infile=0 under [mysqld] so it would look like

Code Select Expand

[mysqld]
local-infile=0

[ring_c]

cat /etc/my.cnf:

Code Select Expand



[xxx@cwp ~]# cat /etc/my.cnf
#
# 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


#
# Disable LOAD DATA LOCAL commands in MySQL
#
local-infile=0



As you can see, the

Code Select Expand

local-infile=0 is there...

[bullten]

You didnt read my whole reply. i told you it should be under [mysqld]

Also when you added local-infile=0 you didnt restart mysql?

so now added it under [mysqld]

#
# 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


#
# Disable LOAD DATA LOCAL commands in MySQL
#
[mysqld]
local-infile=0

Also dont forget to restart mysql

[ring_c]

You didnt read my whole reply. i told you it should be under [mysqld]

Sorry. I'm quite new to VPS in general and CWP in particular. I thought that's what you meant.

Also when you added local-infile=0 you didnt restart mysql?

so now added it under [mysqld]

#
# 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


#
# Disable LOAD DATA LOCAL commands in MySQL
#
[mysqld]
local-infile=0

Also dont forget to restart mysql

I don't really know. I only follow tutorials. Though I'm quite sure I made a server restart 2 days ago...
I will change according to your guidance, restart mysql and will keep an eye on further emails hopping it'll be resolved.


Thanks!

[bullten]

Well you can replicate the issue easily.

in /etc/my.cnf file remove [mysqld] and restart mysql. See if it starts.

[ring_c]

Yes. It does restart!

[bullten]

what is output of

mysqldump

Does it gives same warning like  you mentioned above?

[ring_c]

Sorry, what exactly should I have to run? 

[bullten]

make /etc/my.cnf to look like below as I comment out [mysqld]

nano /etc/my.cnf

#
# 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


#
# Disable LOAD DATA LOCAL commands in MySQL
#
# [mysqld]
local-infile=0

restart mysql

Code Select Expand

service mysqld restart

Does it restart?

run the command below

Code Select Expand

mysqldump

Does the above command gives same warning as you mentioned in the first thread.

[ring_c]

Oh, this time it doesn't restart (I was using the restart button in CWP's dashboard before that, and I didn't get an error then).
Running service mysqld status after the restart command resolves in "ERROR! MariaDB is not running".
And mysqldump resolves in " unknown variable 'local-infile=0' " indeed.


I'll uncomment the [mysqld] and restart mysql again.
But... how come my wordpress sites are working then if the mysql is not running?

[ring_c]

Oh, damn... I've uncommented the [mysqld], saved the file and restarted mysqld.
But the status still shows the error message (though mysqldump doesn't).

[bullten]

Adding that line I think you didnt restart mysql and thats why it happened.

by uncommenting [mysqld] and restarting through ssh did it give any error?

[ring_c]

The last time I did it through SSH.
I still get the same error that MariaDB is not running.

[bullten]

stop mysql

Code Select Expand

service mysqld stop
service mysql stop

Now start from cwp gui