pvimport - load a gzipped sql dump through pv

pimport

#!/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

woot