mysql: Import database with truncated tables.

import_dump.sh

#!/bin/bash

# Usage:
#  $ bash import-dump.sh http://example.co.uk/dump.sql.gz

start=$(date +"%s")

echo "-> Deleting of old tables"

mysql --user=root -e 'DROP DATABASE wikijob;'
mysql --user=root -e 'CREATE DATABASE wikijob;'

echo "-> Downloading and importing of new tables"
curl -H 'Accept-encoding:gzip' $1 | gunzip -c | grep -v 'INSERT INTO `user_relationship_locator_facebook`'| mysql --user=root wikijob

end=$(date +"%s")

diff=$(($end-$start))

echo "Time spent: $(($diff / 60))m$(($diff % 60))s"