diff options
| -rw-r--r-- | myrpki/Makefile | 4 | ||||
| -rw-r--r-- | myrpki/sql-dumper.py | 38 |
2 files changed, 42 insertions, 0 deletions
diff --git a/myrpki/Makefile b/myrpki/Makefile index b83745d8..6823fe07 100644 --- a/myrpki/Makefile +++ b/myrpki/Makefile @@ -42,3 +42,7 @@ graph: verify: sh verify-bpki.sh + +backup: + python sql-dumper.py + tar cvvzf test.$$(TZ='' date +%Y.%m.%d.%H.%M.%S).tgz screenlog.* test backup.*.sql diff --git a/myrpki/sql-dumper.py b/myrpki/sql-dumper.py new file mode 100644 index 00000000..ac98e827 --- /dev/null +++ b/myrpki/sql-dumper.py @@ -0,0 +1,38 @@ +""" +Dump backup copies of SQL tables used by these programs. + +$Id$ + +Copyright (C) 2009 Internet Systems Consortium ("ISC") + +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 ISC DISCLAIMS ALL WARRANTIES WITH +REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY +AND FITNESS. IN NO EVENT SHALL ISC 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. +""" + +import subprocess, ConfigParser + +for name in ("rpkid", "irdbd", "pubd"): + + try: + cfg = ConfigParser.RawConfigParser() + cfg.read("%s.conf" % name) + username = cfg.get(name, "sql-username") + password = cfg.get(name, "sql-password") + database = cfg.get(name, "sql-database") + + except: + print "Cleaner couldn't read %s config file, ignoring" % name + continue + + cmd = ["mysqldump", "-u", username, "-p" + password, "--databases", database] + cmd.extend("%s%d" % (database, i) for i in xrange(12)) + subprocess.check_call(cmd, stdout = open("backup.%s.sql" % name, "w")) |