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

Reply via email to