Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/sh
- # Import a (g|b)zipped SQL dump into a specified database through pipeviewer.
- if [ $# -lt 2 ]; then
- echo "USAGE: $0 <filename> <database>"
- exit 1
- fi
- EXT=${1/*./}
- if [ "$EXT" == "gz" ]; then
- pv -cN source < $1 | gunzip | pv -cN gunzip | mysql $2
- elif [ "$EXT" == "bz2" ]; then
- pv -cN source < $1 | bunzip2 | pv -cN bunzip2 | mysql $2
- else
- echo "File must be .sql.bz2 or .sql.gz"
- fi
Add Comment
Please, Sign In to add comment