6 This script dumps your Bacula catalog in ASCII format
7 It works for MySQL, SQLite, and PostgreSQL
11 make_catalog_backup.pl MyCatalog
15 Bacula® - The Network Backup Solution
17 Copyright (C) 2000-2008 Free Software Foundation Europe e.V.
19 The main author of Bacula is Kern Sibbald, with contributions from
20 many others, a complete list can be found in the file AUTHORS.
22 This program is Free Software; you can redistribute it and/or
23 modify it under the terms of version two of the GNU General Public
24 License as published by the Free Software Foundation plus additions
25 that are listed in the file LICENSE.
27 This program is distributed in the hope that it will be useful, but
28 WITHOUT ANY WARRANTY; without even the implied warranty of
29 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
30 General Public License for more details.
32 You should have received a copy of the GNU General Public License
33 along with this program; if not, write to the Free Software
34 Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
37 Bacula® is a registered trademark of Kern Sibbald.
38 The licensor of Bacula is the Free Software Foundation Europe
39 (FSFE), Fiduciary Program, Sumatrastrasse 25, 8006 Zurich,
40 Switzerland, email:ftf@fsfeurope.org.
44 my $cat = shift or die "Usage: $0 catalogname";
45 my $dir='@sbindir@/bacula-dir -B -c @sysconfdir@/bacula-dir.conf';
46 my $wd = "@working_dir@";
52 exec("echo .dump | sqlite '$wd/$args{db_name}.db' > '$wd/$args{db_name}.sql'");
53 print "Error while executing sqlite dump $!\n";
61 exec("echo .dump | sqlite3 '$wd/$args{db_name}.db' > '$wd/$args{db_name}.sql'");
62 print "Error while executing sqlite dump $!\n";
66 # TODO: use just ENV and drop the pg_service.conf file
71 unlink("$wd/pg_service.conf");
72 open(PG, ">$wd/pg_service.conf")
73 or die "Can't open $wd/pg_service.conf for writing $@";
77 password=$args{db_password}
79 if ($args{db_address}) {
80 print PG "address=$args{db_address}\n";
81 $ENV{PGHOST}=$args{db_address};
84 print PG "port=$args{db_port}\n";
85 $ENV{PGPORT}=$args{db_port};
89 $ENV{PGDATABASE}=$args{db_name};
90 $ENV{PGUSER}=$args{db_user};
91 $ENV{PGPASSWORD}=$args{db_password};
92 exec("HOME='$wd' PGSERVICE=bacula PGSYSCONFDIR='$wd' pg_dump -c > '$wd/$args{db_name}.sql'");
93 print "Error while executing postgres dump $!\n";
94 return 1; # in case of error
101 unlink("$wd/.my.cnf");
102 open(MY, ">$wd/.my.cnf")
103 or die "Can't open $wd/.my.cnf for writing $@";
104 $args{db_address} = $args{db_address} || "localhost";
106 host=$args{db_address}
108 password=$args{db_password}
110 if ($args{db_port}) {
111 print MY "port=%args{db_port}\n";
116 exec("HOME='$wd' mysqldump -f --opt $args{db_name} > '$wd/$args{db_name}.sql'");
117 print "Error while executing mysql dump $!\n";
124 if ($args{db_type} eq 'SQLite') {
126 } elsif ($args{db_type} eq 'SQLite3') {
128 } elsif ($args{db_type} eq 'PostgreSQL') {
130 } elsif ($args{db_type} eq 'MySQL') {
133 die "This database type isn't supported";
137 open(FP, "$dir|") or die "Can't get catalog information $@";
151 if ($l =~ /catalog=(.+)/) {
152 if (exists $cfg{catalog} and $cfg{catalog} eq $cat) {
153 exit dump_catalog(%cfg);
158 if ($l =~ /(\w+)=(.+)/) {
163 if (exists $cfg{catalog} and $cfg{catalog} eq $cat) {
164 exit dump_catalog(%cfg);
167 print "Can't find your catalog ($cat) in director configuration\n";