☰

cPanel 服务器上的 automysqlbackup 不会忽略 eximstats

tag-icon • tag-icon mysql
cPanel 服务器上的 automysqlbackup 不会忽略 eximstats

我正在使用 automysqlbackup 备份我的 cPanel 服务器数据库，在 /etc/automysqlbackup.conf 中我已设置：CONFIG_db_exclude=( 'information_schema' 'cphulkd' 'eximstats' 'leechprotect' 'mysql' 'modsec' )

但我收到了以下错误：

###### WARNING ######
Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
mysqldump: Got error: 145: Table './eximstats/smtp' is marked as crashed and should be repaired when using LOCK TABLES
mysqldump: Couldn't execute 'show create table `Email-List`': SHOW VIEW command denied to user 'automysqlbackup'@'localhost' for table 'Email-List' (1142)
mysqldump: Couldn't execute 'show create table `object_1`': SHOW VIEW command denied to user 'automysqlbackup'@'localhost' for table 'object_1' (1142)
mysqldump: Couldn't execute 'show create table `object_1`': SHOW VIEW command denied to user 'automysqlbackup'@'localhost' for table 'object_1' (1142)
du: WARNING: use --si, not -H; the meaning of the -H option will soon
change to be the same as that of --dereference-args (-D)

我的问题是：

  1. 知道为什么 eximstats 没有被忽略吗？
  2. 鉴于我不是 root 用户（使用 创建的帐户mysql > grant select, lock tables on *.* to 'automysqlbackup'@'localhost' identified by 'password';），如何解决其他错误？

答案1

我有一个非常相似的错误，我最终离开了默认的 mysql 用户，因为automysqlbackup那是为我而设的debian-sys-maint（来自/etc/mysql/debian.cnf）

这个已经设置了适当的权利。

相关内容