Try ... /usr/local/bin/mysqldump -uUserName --opt $db > $location$db.sql
----- Original Message ----- From: "Scott Haneda" <[EMAIL PROTECTED]> To: "Cal Evans" <[EMAIL PROTECTED]>; "MySql" <[EMAIL PROTECTED]> Sent: Saturday, March 01, 2003 5:18 PM Subject: Re: Best way to dump for daily archiving on 03/01/2003 3:03 PM, Cal Evans at [EMAIL PROTECTED] wrote: > use the -opt flag. Can you tell me how to add in the username as well, I get a ./bin/mysqldump: invalid option -- o error Here is the pertinent line /usr/local/bin/mysqldump -uUserName $db > $location$db.sql ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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