3 use POSIX qw(setuid setgid);
6 use File::Temp qw(tempdir);
7 use File::Path qw(rmtree);
10 # path to ini-style config
11 my $config = '/etc/bacula/backup-mysql.conf';
12 my $c = new delfi::mycnf($config);
13 # force reading config file before we switch user
16 # how change to user mysql after we've read config
18 my $uid = getpwnam('mysql');
19 my $gid = getgrnam('mysql');
20 die "Can't find user/group mysql\n" unless $uid or $gid;
28 my $backup_dir = $c->get('options', 'outdir') or die "'outdir' not defined in config\n";
29 my $tmpdir = $c->get('options', 'tmpdir') or die "'tmpdir' not defined in config\n";
31 if (!-d $backup_dir && !mkdir($backup_dir) && !-d $backup_dir) {
32 die "backup dir '$backup_dir' not present and can't be created\n";
34 if (!-d $tmpdir && !mkdir($tmpdir) && !-d $tmpdir) {
35 die "tmpdir '$tmpdir' not present and can't be created\n";
38 # process each cluster
39 for my $cluster ($c->get('clusters', 'cluster')) {
40 print ">>> $cluster\n";
41 backup_cluster($cluster);
42 print "<<< $cluster\n";
46 # Usage: mysqlhotcopy $CLUSTER $DATABASE $USERNAME $PASSWORD $SOCKET
49 my ($cluster, $database, $user, $password, $socket) = @_;
51 my $dstdir = tempdir("bbm.XXXXXX", DIR => $tmpdir);
53 # make backup with mysqlhotcopy
54 my @shell = ('mysqlhotcopy');
55 push(@shell, '-u', $user) if $user;
56 push(@shell, '-p', $password) if $password;
57 push(@shell, '-S', $socket) if $socket;
58 push(@shell, $database, $dstdir);
59 system(@shell) == 0 or die "mysqlhotcopy failed: $?\n";
61 # put it to "production dir"
62 my $cluster_dir = "$backup_dir/$cluster";
63 if (!-d $cluster_dir && !mkdir($cluster_dir) && !-d $cluster_dir) {
64 die "cluster dir '$cluster_dir' not present and can't be created\n";
67 my $dirname = "$backup_dir/$cluster/$database";
72 my $srcdir= "$dstdir/$database";
73 rename($srcdir, $dirname) or die "Rename '$srcdir'->'$dirname' failed: $!\n";
75 rmdir($dstdir) or warn $!;
81 # get db connection info
82 my $user = $c->get($cluster, 'user') || $c->get('client', 'user');
83 my $password = $c->get($cluster, 'password') || $c->get('client', 'password');
84 my $socket = $c->get($cluster, 'socket') || $c->get('client', 'socket');
86 # get databases to backup
89 my @include = $c->get($cluster, 'include_databases');
90 my @exclude = $c->get($cluster, 'exclude_databases');
91 if (@exclude or !@include) {
92 my $dbh = new DB($user, $password, $socket);
93 my $sth = $dbh->prepare("show databases");
95 while (my($dbname) = $sth->fetchrow_array) {
96 next if lc($dbname) eq 'information_schema';
97 push @dbs, $dbname unless grep { m{^\Q$dbname\E$} } @exclude;
103 foreach my $db (@dbs) {
104 mysqlhotcopy($cluster, $db, $user, $password, $socket);
110 # DB class for simple Database connection
113 my $class = ref($self) || $self;
115 my ($user, $password, $socket) = @_;
117 $dsn .= "mysql_socket=$socket" if $socket;
118 my $dbh = DBI->connect("DBI:mysql:$dsn", $user, $password, { PrintError => 0, RaiseError => 1 });