Author Topic: Error found on the email from - Anacron job 'cron.daily'  (Read 32697 times)

0 Members and 1 Guest are viewing this topic.

Offline
***
Re: Error found on the email from - Anacron job 'cron.daily'
« Reply #30 on: September 07, 2018, 04:09:56 PM »
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

Offline
**
Re: Error found on the email from - Anacron job 'cron.daily'
« Reply #31 on: September 08, 2018, 07:30:30 PM »
Wow, bulletn, thank you so much for thinking of me!!!

Offline
**
Re: Error found on the email from - Anacron job 'cron.daily'
« Reply #32 on: September 08, 2018, 08:03:02 PM »
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