我使用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)
我的问题是:
mysql > grant select, lock tables on *.* to 'automysqlbackup'@'localhost' identified by 'password';创build的帐户mysql > grant select, lock tables on *.* to 'automysqlbackup'@'localhost' identified by 'password'; )如何解决其他错误? 我有一个相当类似的错误,我终于离开了默认的mysql用户automysqlbackup这是我debian-sys-maint (从/etc/mysql/debian.cnf )
这一个已经有适当的权利设置。