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' 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 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! Kelly S. Brace Information Technology Exchange Center Twin Rise 200 1300 Elmwood Avenue Buffalo, NY 14222 http://www.itec.suny.edu Main: 716-878-4832 Fax: 716-878-3485 Office: 716-878-3895 Cell: 716-432-4978 [EMAIL PROTECTED]
