Re: mysqldump permissions

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.piggott@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