BACKUP TABLE help

[Michael Collins <mcollins@xxxxxxxxxx>]

I get a permission error when trying to backup my database files 
using the BACKUP TABLE function, here is an example use and its 
result:

BACKUP TABLE ai2.topics TO "/Users/mcollins/BACKUPS/BACKUP_1126_1407/ai2/";
+------------+--------+----------+--------------------------------------+
| Table      | Op     | Msg_type | Msg_text                             |
+------------+--------+----------+--------------------------------------+
| ai2.topics | backup | error    | Failed copying .frm file: errno = 13 |
| ai2.topics | backup | status   | Operation failed                     |
+------------+--------+----------+--------------------------------------+
2 rows in set (0.01 sec)

When running this I am logged into mysql client program as root 
(using a root shell). The folder being backed up to exists already:

[localhost:~] root# ls -al /Users/mcollins/BACKUPS/BACKUP_1126_1407/
drwxr-xr-x   2 root  staff    24 Nov 26 14:07 ai2

Here are the permissions on the data files:

[localhost:~] root# ls -al /usr/local/mysql/data
drwxrwxr-x   5 mysql  wheel   126 Nov 25 15:07 ai2

[localhost:~] root# ls -al /usr/local/mysql/data/ai2
-rwxrwxr-x   1 mysql  wheel  3942880 Nov 25 15:24 topics.MYD
-rwxrwxr-x   1 mysql  wheel    31744 Nov 25 15:24 topics.MYI
-rwxrwxr-x   1 mysql  wheel     9332 Nov 25 15:07 topics.frm

Since I am logged in as root, shouldn't the Backup be possible?

BTW, I am using 3.23.44 and MyISAM tables, is the BACKUP TABLE the 
best method for backing up databases? Better than mysqldump?

--
Michael
__
||| Michael Collins       |||
||| Kuwago Web Services   |||      mailto:mcollins@xxxxxxxxxx
||| Seattle, WA, USA      |||      http://www.lassodev.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 <mysql-thread92274@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php