Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
#!/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
You can’t perform that action at this time.