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: Cou
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 databas
