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, 2
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
---
On 01-Mar-2003 Scott Haneda wrote:
> I wrote a sh script to use mysqldump to iterate through my databases and
> dump them to .sql files, I am supplying no flags to mysqldump, and wonder,
> is there a "best way" to dump your files, if the idea is they are backups
> and to be used in the case of eme
use the -opt flag.
=C=
* Cal Evans
* Stay Plugged Into Your Audience
* http://www.christianperformer.com
-Original Message-
From: Scott Haneda [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 4:27 PM
To: MySql
Subject: Best way to dump for daily archiving
I wrote a sh script t
