Mysql error when backing up cPanel
Hello,
Im having the following situation:
Whenever the daily cron tries to backup the database, it throws this error.
I dont have the folder /backup/mysql, instead i have within the compressed tar file with the user the dump of the databases.
Does someone knows how to fix this issue?
Thank you very much!
/etc/cron.daily/cwp:
====================================================
============= CentOS Web Panel Cron ================
====================================================
###########################
Firewall Flush Daily Blocks
###########################
######################
Update Server Packages
######################
Date which backup script is using: 2018-11-12 02:23:11
###############################################
Daily Files Backup starting
###############################################
Username: ####
========================================
sending incremental file list
sent 263,475 bytes received 1,621 bytes 176,730.67 bytes/sec
total size is 62,019,102 speedup is 233.95
###############################################
Daily Files Backup finished
###############################################
###############################################
Daily MySQL Backup starting
###############################################
Skipping database: information_schema.
Database Backup: mysql --> /backup/mysql/daily//mysql.sql
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
Database Backup: postfix --> /backup/mysql/daily//postfix.sql
Database Backup: root_cwp --> /backup/mysql/daily//root_cwp.sql
Database Backup: roundcube --> /backup/mysql/daily//roundcube.sql
Database Backup: webdal_webjob --> /backup/mysql/daily//webdal_webjob.sql
warning: /var/tmp/rpm-tmp.wJuc7Y: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
error: Failed dependencies:
perl(DBD::mysql) >= 1.0 is needed by percona-toolkit-2.2.16-1.noarch
###############################################
Daily MySQL Backup finished
###############################################
cpulimit: no process found Please sign in to leave a comment.
Comments
0 comments