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 $ENV{PATH}="@SQL_BINDIR@:$ENV{PATH}";
46 my $cat = shift or die "Usage: $0 catalogname";
47 my $dir_conf='@sbindir@/dbcheck -B -c @sysconfdir@/bacula-dir.conf';
48 my $wd = "@working_dir@";
54 exec("echo .dump | sqlite '$wd/$args{db_name}.db' > '$wd/$args{db_name}.sql'");
55 print "Error while executing sqlite dump $!\n";
63 exec("echo .dump | sqlite3 '$wd/$args{db_name}.db' > '$wd/$args{db_name}.sql'");
64 print "Error while executing sqlite dump $!\n";
68 # TODO: use just ENV and drop the pg_service.conf file
74 if ($args{db_address}) {
75 $ENV{PGHOST}=$args{db_address};
78 $ENV{PGPORT}=$args{db_port};
81 $ENV{PGDATABASE}=$args{db_name};
82 $ENV{PGUSER}=$args{db_user};
83 $ENV{PGPASSWORD}=$args{db_password};
84 exec("HOME='$wd' pg_dump -c > '$wd/$args{db_name}.sql'");
85 print "Error while executing postgres dump $!\n";
86 return 1; # in case of error
93 unlink("$wd/.my.cnf");
94 open(MY, ">$wd/.my.cnf")
95 or die "Can't open $wd/.my.cnf for writing $@";
96 $args{db_address} = $args{db_address} || "localhost";
98 host=$args{db_address}
100 password=$args{db_password}
102 if ($args{db_port}) {
103 print MY "port=$args{db_port}\n";
108 exec("HOME='$wd' mysqldump -f --opt $args{db_name} > '$wd/$args{db_name}.sql'");
109 print "Error while executing mysql dump $!\n";
116 if ($args{db_type} eq 'SQLite') {
118 } elsif ($args{db_type} eq 'SQLite3') {
120 } elsif ($args{db_type} eq 'PostgreSQL') {
122 } elsif ($args{db_type} eq 'MySQL') {
125 die "This database type isn't supported";
129 open(FP, "$dir_conf|") or die "Can't get catalog information $@";
143 if ($l =~ /catalog=(.+)/) {
144 if (exists $cfg{catalog} and $cfg{catalog} eq $cat) {
145 exit dump_catalog(%cfg);
150 if ($l =~ /(\w+)=(.+)/) {
155 if (exists $cfg{catalog} and $cfg{catalog} eq $cat) {
156 exit dump_catalog(%cfg);
159 print "Can't find your catalog ($cat) in director configuration\n";