aboutsummaryrefslogtreecommitdiff
path: root/scripts/blow-away-databases.sh
blob: 2d4917724a8731fcee472e421c69ec5bda39436e (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
#!/bin/sh -
# $Id$

echo "This script destroys and rebuilds our databases."
echo "Don't type the password unless you're sure you want to do this."

(echo 'DROP DATABASE rpki; CREATE DATABASE rpki; USE rpki;'
 cat ../docs/rpki-db-schema.sql
 echo 'DROP DATABASE irdb; CREATE DATABASE irdb; USE irdb;'
 cat ../docs/sample-irdb.sql
) |
mysql -u root -p