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
D]
> 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 usi
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" | g
