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


I created a VIEW =E2=80=9Ctable=E2=80=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


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 =E2=80=93uUSER =E2=80=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.

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

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

--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" <ron.piggott [at] actsministries.org> 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--