Output:#!/usr/bin/perl -w use strict; use warnings; #Variables my $fbbin = "/opt/firebird/bin/"; my $data = "/opt/databases/"; my $ext = "gdb"; #my $shared = "/opt/shared/"; my $tempdir = "/opt/backup/"; #my $destdir = "/home/mery/backup/complete/"; #my $usbdev = "/dev/sdc1/"; #my $localdir = "/mnt/storage/testy/"; #my $mailerr = "core-powiadomienia\@core.com.pl"; my $klient = "PanTester"; my $mailtopic = "Raport nocnej kopii zapasowej w firmie $klient"; use POSIX(); print POSIX::strftime('%Y-%m-%d-%H-%M-%S', localtime); #Create database filenames table @files my $type = $ext; my $dir = $data; $type = "*.$type"; print "looking for files with extension $type \n"; chdir ($dir); my @files = qx(ls $type 2>&1); foreach (@files) { print "Found database: $_\n"; } # This loop run external gbak backup command to create $_.gbk files as + output in $tempdir foreach (@files) { chdir ($fbbin); # print "Tworze kopie bazy $_ \n"; system("./gbak -user sysdba -password masterkey -BACKUP_DATABA +SE localhost\:$data$_ $tempdir`$_.gbk`") or die "Blad archiwizowania +bazy $_ \n"; # print "Gotowa kopia bazy $_ \n"; }
/opt/backup is chmoded to 777 and owned by nobody.nogroup (it`s testing virtual machine so i`m not worried about security ;)) so i don`t understand why permission denied.2012-02-28-22-23-33looking for files with extension *.gdb Found database: demo2.gdb Found database: demo.gdb Found database: SimpleMarketing2.gdb Found database: simplemarketing.gdb gbak: ERROR:requires both input and output filenames gbak:Exiting before completion due to errors sh: 1: demo2.gdb: not found sh: 2: .gbk: not found sh: 3: /opt/backup/: Permission denied gbak: ERROR:requires both input and output filenames gbak:Exiting before completion due to errors sh: 1: demo.gdb: not found sh: 2: .gbk: not found sh: 3: /opt/backup/: Permission denied gbak: ERROR:requires both input and output filenames gbak:Exiting before completion due to errors sh: 1: SimpleMarketing2.gdb: not found sh: 2: .gbk: not found sh: 3: /opt/backup/: Permission denied gbak: ERROR:requires both input and output filenames gbak:Exiting before completion due to errors sh: 1: simplemarketing.gdb: not found sh: 2: .gbk: not found sh: 3: /opt/backup/: Permission denied
In reply to Re: Firebird databases backup script
by Mery84
in thread Firebird databases backup script
by Mery84
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |