#!/bin/sh - # $Id$ # Copyright (C) 2007--2008 American Registry for Internet Numbers ("ARIN") # # Permission to use, copy, modify, and distribute this software for any # purpose with or without fee is hereby granted, provided that the above # copyright notice and this permission notice appear in all copies. # # THE SOFTWARE IS PROVIDED "AS IS" AND ARIN DISCLAIMS ALL WARRANTIES WITH # REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY # AND FITNESS. IN NO EVENT SHALL ARIN BE LIABLE FOR ANY SPECIAL, DIRECT, # INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM # LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE # OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR # PERFORMANCE OF THIS SOFTWARE. # GRANT ALL ON rpki.* TO rpki@localhost IDENTIFIED BY ''; # GRANT ALL ON irdb.* TO irdb@localhost IDENTIFIED BY ''; 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 one-cleanup&id=05c0952a9b13a4822edb0a8a4b9c0348dfaf0687'>refslogtreecommitdiff
blob: d3798a32a0da1308de7d10f7c2fb61b5ce53a3a7 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40