Give the user show view permission
http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_show-view
On 06/06/2011 7:57 AM, Ron Piggott ron.pigg...@actsministries.org wrote:
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