mysqldump permissions

------=_NextPart_000_003E_01CC23A9.D71F2710
Content-Type: text/plain;
charset="UTF-8"
Content-Transfer-Encoding: quoted-printable


I created a VIEW â€=9Ctableâ€=9D 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=20


I use the following syntax to do the backup of the database each day =
within the context of a cron job:


date=3D`date -I` ; mysqldump â€=93uUSER â€=93pPASS =
--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. =20

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
â€=9CEncouragement from Godâ€=99s Wordâ€=9D
http://www.TheVerseOfTheDay.info =20

------=_NextPart_000_003E_01CC23A9.D71F2710--

Re: mysqldump permissions

--0015174c1c5ce1f36a04a4fecd08
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

Give the user show view permission
http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.h tml#priv_show-v=
iew
On 06/06/2011 7:57 AM, "Ron Piggott" wrote=
:
>
> I created a VIEW =93table=94 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=3D`date -I` ; mysqldump =96uUSER =96pPASS --all-databases | gzip >
/home/path/backup_$date.sql.gz
>
>
> Even when I have given the mysql backup user all the permissions availabl=
e
within the control panel of my web site hosting company I still get the sam=
e
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
> =93Encouragement from God=92s Word=94
> http://www.TheVerseOfTheDay.info

--0015174c1c5ce1f36a04a4fecd08--