Michael Collins wrote:
> I could not get the backup to work using the mysql client program. The
> table is a MyISAM type and I have a version (3.23.36) that should
> support the BACKUP TABLE SQL command.
>
> First I created a directory called "dbbackup" and then used the following:
>
> mysql> BACKUP TABLE Example.Import_Web TO '/dbbackup';
> +--------------------+--------+----------+--------------------------------------+
>
> | Table | Op | Msg_type | Msg_text |
> +--------------------+--------+----------+--------------------------------------+
>
> | Import_Web | backup | error | Failed copying .frm file:
> errno = 13 |
> | Example.Import_Web | backup | status | Operation failed |
> +--------------------+--------+----------+--------------------------------------+
>
> 2 rows in set (0.02 sec)
>
> Anyone recognize the error?
Use the utility "perror" to get meaning of OS low level errors. This is
an "Access denied" and means that in some reason you are not allowed to
write into this "/" directory. I think, this is normal :)
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Tonu Samuel <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator
/_/ /_/\_, /___/\___\_\___/ Hong Kong, China
<___/ www.mysql.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