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

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]

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]

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

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

Well, I did get this:

Code: [Select]

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


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