Try ...
/usr/local/bin/mysqldump -uUserName --opt $db > $location$db.sql
----- Original Message -----
From: "Scott Haneda" <lists@stripped>
To: "Cal Evans" <cal@stripped>; "MySql" <mysql@stripped>
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 cal@stripped 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
scott@stripped 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 <mysql-thread133755@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-autodata=execpc.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php