#!/bin/bash
if [ "$1" == "" ]; then
echo "Usage: $0 [output-path]"
exit 1
fi
TABLES=`mysql -B -N -e "select TABLE_NAME from information_schema.TABLES where TABLE_SCHEMA='$1'"`
OUT="$2"
if [ "$OUT" == "" ]; then
OUT="."
fi
if [ ! -d $OUT ]; then
echo "$OUT does not exist"
exit 1
fi
for table in $TABLES; do
echo -n "dumping $1.$table..."
mysqldump $1 $table > $OUT/$1.$table.sql
echo "done"
done