Re: an backup syntax error

2006-01-05 Thread gerald_clark 
wangxu wrote:

Follow is my preform and result:
-
mysql backup table ht_detail to '/';
+++--+--+
| Table  | Op | Msg_type | Msg_text |
+++--+--+
| test.ht_detail | backup | error| Failed copying .frm file (errno: 13) |
| test.ht_detail | backup | status   | Operation failed |
+++--+--+
2 rows in set, 1 warning (0.00 sec)

-

How to solve it?
I use 5.0.16.

Normal users cannot write to the root directory.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

an backup syntax error

2006-01-04 Thread wangxu 
Follow is my preform and result:
-
mysql backup table ht_detail to '/';
+++--+--+
| Table  | Op | Msg_type | Msg_text |
+++--+--+
| test.ht_detail | backup | error| Failed copying .frm file (errno: 13) |
| test.ht_detail | backup | status   | Operation failed |
+++--+--+
2 rows in set, 1 warning (0.00 sec)

-

How to solve it?
I use 5.0.16.

RE: an backup syntax error

2006-01-04 Thread Logan, David (SST - Adelaide) 
Hi,

The error message (errno: 13) indicates a permissions problem. Check the
permissions of the user that is running the backups or, alternatively,
check the permissions that are set for this file.

Regards


---
** _/ **  David Logan 
***   _/ ***  ITO Delivery Specialist - Database
*_/*  Hewlett-Packard Australia Ltd
_/_/_/  _/_/_/    E-Mail: [EMAIL PROTECTED]
   _/  _/  _/  _/     Desk:   +618 8408 4273
  _/  _/  _/_/_/  Mobile: 0417 268 665
*_/   **
**  _/    Postal: 148 Frome Street,
   _/ **  Adelaide SA 5001
  Australia 
invent   
---

-Original Message-
From: wangxu [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 5 January 2006 1:29 PM
To: mysql@lists.mysql.com
Subject: an backup syntax error 

Follow is my preform and result:
-
mysql backup table ht_detail to '/';
+++--+--
+
| Table  | Op | Msg_type | Msg_text
|
+++--+--
+
| test.ht_detail | backup | error| Failed copying .frm file (errno:
13) |
| test.ht_detail | backup | status   | Operation failed
|
+++--+--
+
2 rows in set, 1 warning (0.00 sec)

-

How to solve it?
I use 5.0.16.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]