Re: BACKUP TABLE help

[Paul DuBois <paul@xxxxxxxxx>]

At 2:53 PM -0800 11/26/01, Michael Collins wrote:
> 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?

It doesn't matter who you are logged as.  You're not doing the backup,
the MySQL server is doing it.  So what matters for permissions is what
user account the server is running as.  Of course, if the server is
running as root, too, it should be able to write the file -- but that is
a BIG security risk.

> 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-thread92276@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php