Kelly, You can find out what user mysqld is running as with the following:
#ps axu | grep mysqld To change the permissions on the directory run the following as root: #chown mysql.mysql /usr/local/mysql/bakups #chmod 770 /usr/local/mysql/bakups If it is a different user, substitute it in for mysql in the first command. -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa On Thursday, March 03, 2005 13:58, [EMAIL PROTECTED] wrote: > Tom, > I seem to be having difficulty allowing the mysqld user wx privs on > the /backup folder. I read the following, but I don't see how to > allow mysqld to w and x to that directory: > http://dev.mysql.com/doc/mysql/en/mysqldump.html > > Kelly > > On Thursday, March 03, 2005 13:12, [EMAIL PROTECTED] > wrote: > > Hi Kelly, > >> Hello, >> When I attempt to try and run the backup: >> >> shell> mysqldump --tab=/path/to/some/dir --opt db_name >> I get the following errors: >> ./mysqldump: Got error: 1: Can't create/write to file >> '/usr/local/mysql/bakups/config.txt' (Errcode: 13) when executing >> 'SELECT INTO OUTFILE' > > [EMAIL PROTECTED] tom]$ perror 13 > Error code 13: Permission denied > > You need to make sure that the user mysqld is running as has write and > execute permission to /usr/local/mysql/bakups. > > Read the following page. Specifically the part about the tab option. > http://dev.mysql.com/doc/mysql/en/mysqldump.html > >> Or: >> >> shell> mysqlhotcopy db_name /path/to/some/dir >> DBI->connect(;host=localhost;mysql_read_default_group=mysqlhotcopy) >> failed: Client does not support authentication protocol requested by >> server; consider upgrading MySQL client at ./mysqlhotcopy line 178 > > You need a newer version of DBD-mysql (you can get this from CPAN), > or you can use the old password option. > > http://dev.mysql.com/doc/mysql/en/old-client.html > >> I followed the directions from: >> http://dev.mysql.com/doc/mysql/en/backup.html >> >> I also attempted to follow these directions, to no avail: >> ---------------------------------- >> mysqlhotcopy, etc is great - but using it (and most other myql >> automation scripts) requires placing a user/password on the command >> line for all/some to see (ps axw) >> There doesn't appear to be a way to place the user/pass into a file >> somewhere and specify only that (secured) filename on the command >> line. I get around this in the case of mysqlhotcopy by taking a >> local copy of the script (perl) and hard-coding the auth info into >> that copy thus: >> >> mysqlhotcopy - line 164ish: >> >> my $dbh = >> DBI->connect("dbi:mysql:$dsn;mysql_read_default_group=mysqlhotcopy", >> 'backup_user', 'backup_password'}, >> >> and again at around line 745: >> >> my $dbh = >> > DBI->connect("dbi:mysql:${db}${dsn};mysql_read_default_group=mysqlhotcopy", >> "backup_user", "backup_password", >> >> then, just to be sure, >> >> chown root.nobody mysqlhotcopy >> chmod 700 mysqlhotcopy >> -------------------------------- >> Any ideas would be greatly appreciated. I would really like to add >> this to a cronjob to have it run automatically. Thanks in advance! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
