blob: 51e5602fedcbde051b23d17a32ae6c5e8a80a91f (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
#!/bin/zsh
echo -n 'Database root PW (for DB creation): '
read -s ROOTPW
echo
echo -n 'Database user for new DB: '
read DBUSER
echo -n 'Database user PW for new DB: '
read -s DBPASSW
echo
mysql -u root -p"$ROOTPW" -B <<EOF
CREATE DATABASE $2;
GRANT ALL ON $2.* to '$DBUSER'@'localhost';
EOF
unset ROOTPW
mysqldump -u "$DBUSER" -p"$DBPASSW" "$1" \
| mysql -u "$DBUSER" -p"$DBPASSW" "$2"
|