Check the manual to make sure, but I believe that you need to also make sure
that the operating system privileges are set correctly too. Not sure what
you'll need in Windows, but in Linux, your hosting company probably runs
MySQL under the user mysql. Thus, for the database to write out the data for
BACKUP, it needs _unix_ write privileges for user mysql (can be group too).
If you are trying to backup a table to a directory in your log-in directory,
you need to make sure that the MySQL daemon has write privileges to the
backup directory.
Best,
Kyle
On Sunday 18 March 2001 05:24, Tom Bellucco wrote:
> Hi,
>
> My web host just upgraded from a version that did not support the BACKUP
> TABLE command (3.22.??) to the latest. What I try to execute the BACKUP
> TABLE command it fails with an access denied error. He says I have all the
> necessary privileges, but I have the feeling something is missing. When I
> execute SHOW GRANTS it says I have all privileges, but I wonder if there is
> a new privilege for backuup that doesn't get turned on by default. Any
> help would be appreciated, please copy responses to my email as I am a new
> subscriber and am concerned about missing any replies.
>
> Thanks!
>
> --
> Tom Bellucco
> TJ Computers & Consulting
> [EMAIL PROTECTED]
> www.tjcc.com
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
*************************************************************************
"HEAR THE DIFFERENCE" with a live MicroTelco Gateway
demo at: Voice on the Net (VON), March 20-23, Phoenix AZ.
For more information visit: http://www.microtelco.com.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
