From 515d2bb27d350e55afd393c17c004cb3bebb353d Mon Sep 17 00:00:00 2001 From: Rob Austein Date: Thu, 7 Oct 2010 19:31:54 +0000 Subject: Use -B to get CREATE DATABASES svn path=/rpkid/backup-sql.py; revision=3469 --- rpkid/backup-sql.py | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/rpkid/backup-sql.py b/rpkid/backup-sql.py index 30202dc8..cdf5beac 100644 --- a/rpkid/backup-sql.py +++ b/rpkid/backup-sql.py @@ -40,10 +40,10 @@ cfg = rpki.config.parser(cfg_file, "myrpki") def dump(section): subprocess.check_call( - ("mysqldump", - "-u", cfg.get("sql-username", section = section), + ("mysqldump", "--add-drop-database", + "-u", cfg.get("sql-username", section = section), "-p" + cfg.get("sql-password", section = section), - cfg.get("sql-database", section = section))) + "-B", cfg.get("sql-database", section = section))) if cfg.getboolean("run_rpkid", False): dump("irdbd") -- cgit v1.2.3