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
mysqldump -u$dbuser -p$dbpassword $dbname | zip -q9
$destdir/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
> Subject: RE: Backing up all MySQL DBs
>
>
> > 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: Backing up all MySQL DBs
> > >
> > >
> > > Hi everybody
> > > I'm pretty new to MySQL (and to this list). My problem is I need to
get
> > > a dump of all databases in seperate files, I know how to do one
> > > database to one file and all databases to one file.
> > > So far I'm using this command:
> > > mysqldump --user "$USERNAME" --password="$PASSWORD" "$DBNAME" | gzip>
> > > "$DBNAME"db_"$DATE".sql.gz
> > >
> > > Is there a way selecting all databases?
> > >
> > > Ren� M�lsted
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
> > >
> > >
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
> >
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
