问个MYSQLDUMP的报错问题。

tim707 发表于 2013-02-18 15:59

刚接触MYSQL，执行一个脚本，报错，脚本内容如下：
#!/bin/bash
#Set the varible.
PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:~/bin
# Get the date messages and backup directory
backuptime=`date +%Y%m%d%H%M%S_%N`
backupdir=/mnt/backup/db/
backuppre=db_backup_
# MySQL infomation
HOST=127.0.0.1
PORT=3307
USER=root
#PASS=password
BACKUPDBFILE=$backupdir$backuppre$backuptime.sql
echo $BACKUPDBFILE
mysqldump -u$USER -h$HOST -P$PORT --all-databases --lock-all-tables --add-drop-database --add-drop-table --comments --complete-insert --default-character-set=utf8 --result-file=$BACKUPDBFILE
echo "$BACKUPDBFILE -> $BACKUPDBFILE.bz2"
bzip2 -z $BACKUPDBFILE

报错内容如下：.sql0218155329_489077000
mysqldump: Couldn't execute 'FLUSH TABLES': Access denied; you need the RELOAD privilege for this operation (1227)
.bz20218155329_489077000

望有经验的朋友解答一下，感谢！

页: [1]

Chinaunix's Archiver

问个MYSQLDUMP的报错问题。