1
#!/bin/bash
2
3
export user=$1
4
export password=$2
5
export DB=$3
6
export SCR=$4
7
8
mysqldump -u $user --password=$password -c -t --hex-blob $DB > /tmp/$DB.sql
9
mysqladmin -u $user --password=$password -f drop $DB
10
mysqladmin -u $user --password=$password create $DB
11
mysql -u $user --password=$password $DB < $SCR
12
mysql -u $user --password=$password $DB < /tmp/$DB.sql