This file looks large and may slow your browser down if we attempt
to syntax highlight it, so we are showing it without any
pretty colors.
Highlight
it anyway.
| 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 |