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
