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 emergency.
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
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
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
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