Bash script that dumps all the tables of a given database, each table to its own file.

MySQL Dump Tables

#!/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