Backing up all MySQL DBs - René Mølsted - com.mysql.lists.mysql

4 messages in com.mysql.lists.mysqlBacking up all MySQL DBs

From	Sent On	Attachments
René Mølsted	08 Sep 2003 10:51
Mike Hillyer	08 Sep 2003 21:02
Will Glass-Husain	09 Sep 2003 06:47
Jerry M. Howell II	10 Sep 2003 02:24

Subject:	Backing up all MySQL DBs
From:	René Mølsted (mols...@mgraphics.dk)
Date:	09/08/2003 10:51:06 AM
List:	com.mysql.lists.mysql

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?