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

[bullten]

We dont usually use backup for cwp servers but today used it on one server and it gave the error as you mentioned error. Below is its resolution

Code Select Expand

yum install perl-DBD-MySQL -y
rpm -Uvh http://dl1.centos-webpanel.com/files/mysql/percona-toolkit.rpm

Rerun the backup and it will be fine now.

Code Select Expand

/usr/local/cwp/php71/bin/php -d max_execution_time=1000000 -q /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php

[ring_c]

Wow, bulletn, thank you so much for thinking of me!!!

[ring_c]

Well, I did get this:

Code Select Expand

Database Backup: oauthv2 --> /backup/mysql/daily//oauthv2.sql
mysqldump: Got error: 1142: "SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'accounts'" when using LOCK TABLES
Database Backup: performance_schema --> /backup/mysql/daily//performance_schema.                                                                                                                                                             sql


[bullten]

http://forum.centos-webpanel.com/backup/mysqldump-got-error-1142-'select-lock-tables/msg19058/#msg19058