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]