Skip to content

Instantly share code, notes, and snippets.

@fuzzysteve

fuzzysteve/dumptables.sh

Created September 5, 2013 11:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fuzzysteve/6449163 to your computer and use it in GitHub Desktop.
Save fuzzysteve/6449163 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
dumptables.sh
#!/bin/bash
DB=sdeodyssey11
DIR=/home/dump/
for i in `echo "show tables" | mysql $db|grep -v Tables_in_`;
do
FILE=$DIR/$i
echo $i;
mysqldump --default-character-set=utf8 $DB $i -r $FILE.sql --opt --allow-keywords
done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment