From 6c7445cce4c8a05c3e762fd1d537c54d6ea1fc8c Mon Sep 17 00:00:00 2001 From: Rob Austein Date: Fri, 22 Jan 2010 21:55:09 +0000 Subject: Branch myrpki code before starting rototill based on feedback from Tokyo workshop. svn path=/myrpki.rototill; revision=2958 --- myrpki.rototill/sql-dumper.py | 35 +++++++++++++++++++++++++++++++++++ 1 file changed, 35 insertions(+) create mode 100644 myrpki.rototill/sql-dumper.py (limited to 'myrpki.rototill/sql-dumper.py') diff --git a/myrpki.rototill/sql-dumper.py b/myrpki.rototill/sql-dumper.py new file mode 100644 index 00000000..849d0eb1 --- /dev/null +++ b/myrpki.rototill/sql-dumper.py @@ -0,0 +1,35 @@ +""" +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 + +cfg = ConfigParser.RawConfigParser() +cfg.read("yamltest.conf") + +for name in ("rpkid", "irdbd", "pubd"): + + try: + passwd = cfg.get("yamltest", "%s_db_pass" % name) + except: + passwd = "fnord" + + cmd = ["mysqldump", "-u", name[:4], "-p" + passwd, "--databases", name[:4]] + cmd.extend("%s%d" % (name[:4], i) for i in xrange(12)) + subprocess.check_call(cmd, stdout = open("backup.%s.sql" % name, "w")) -- cgit v1.2.3