Re: Backing up all MySQL DBs

2003-09-10 Thread Jerry M. Howell II
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

Re: Backing up all MySQL DBs

2003-09-09 Thread Will Glass-Husain
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

RE: Backing up all MySQL DBs

2003-09-08 Thread Mike Hillyer
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