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! -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]