#!/bin/bash

USER="root"
PASSWORD="root"
OUTPUTDIR="/Applications/MAMP/backup/"
MYSQLDUMP="/Applications/MAMP/Library/bin/mysqldump"
MYSQL="/Applications/MAMP/Library/bin/mysql"

# clean up any old backups - save space
rm "$OUTPUTDIR/*sql" > /dev/null 2>&1

# get a list of databases
databases=`$MYSQL --user=$USER --password=$PASSWORD \
 -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`

# dump each database in turn
for db in $databases; do
    echo $db
    $MYSQLDUMP --force --opt --user=$USER --password=$PASSWORD \
    --databases $db > "$OUTPUTDIR/$db.sql"
done