[PHP-DB] mysqldump permissions

2011-06-05 Thread Ron Piggott
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

Re: [PHP-DB] mysqldump permissions

2011-06-05 Thread kesavan trichy rengarajan
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