blob: c2ee4b8d5b917efa9b415b8680e3f409b939bf6c (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
#!/bin/sh -
# $Id$
# GRANT ALL ON rpki.* TO rpki@localhost IDENTIFIED BY '<secret>';
# GRANT ALL ON irdb.* TO irdb@localhost IDENTIFIED BY '<secret>';
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
|
