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:[EMAIL PROTECTED] ||| 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
