Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement