On Tue, Sep 09, 2003 at 06:47:52AM -0700, Will Glass-Husain wrote:
>
>
> There's also
>
> # backup databases
> for dbname in `echo 'show databases;' | mysql -u$dbuser -p$dbpassword`
> do
> echo "Backing up database $dbname..." >>
> $destdir/backup.log
> mysqldum
ir/db_$dbname.zip - >> $destdir/backup.log
done
WILL
[EMAIL PROTECTED]
- Original Message -
> From: "Mike Hillyer" <[EMAIL PROTECTED]>
> To: "René Mølsted" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Monday, September 08, 2003 9:02 PM
Sure, use the --all-databases option instead of $DBNAME
http://www.mysql.com/doc/en/mysqldump.html
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: René Mølsted [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 08, 2003 11:51 AM
> To: [EMAIL PROTECTED]
> Subject: Back