mysqldump permissions
| From: | Ron Piggott | Date: | Sun, 05 Jun 2011 21:56:05 +0000 |
| Subject: | mysqldump permissions | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-47836@lists.php.net to get a copy of this message | ||
I created a VIEW “table” yesterday. Last night when the cron job ran to back up the database I
received this error:
mysqldump: Couldn't execute 'show create table
bible_anagrams_rss_feed_summary': SHOW VIEW command denied to user
I use the following syntax to do the backup of the database each day within the context of a cron
job:
date=date -I ; mysqldump –uUSER –pPASS --all-databases | gzip >
/home/path/backup_$date.sql.gz
Even when I have given the mysql backup user all the permissions available within the control panel
of my web site hosting company I still get the same error. These are the permissions I have
available.
SELECT
INSERT
UPDATE
DELETE
INDEX
CREATE TEMPORARY TABLE
EXECUTE
CREATE
ALTER
DROP
LOCK TABLES
REFERENCES
CREATE ROUTINE
How to resolve the error?
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info