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" 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