blob: 6b41fd4f5813b90d71d4a19f25da50f89b61e2f7 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
#!/bin/zsh
echo -n 'Database root PW (for DB manipulation): '
read -s ROOTPW
echo
mysql -u root -p"$ROOTPW" -B <<EOF
DROP DATABASE $2; CREATE DATABASE $2;
EOF
echo "Recreated database $2"
mysqldump -u root -p"$ROOTPW" "$1" \
| mysql -u root -p"$ROOTPW" -B "$2"
echo "Copied $1 to $2"
|