Hi
I'm trying to backup MySQL database using bacula and a FifoStorage. First I
configure a script named "backwithfifo" which dumps the database.
#!/bin/sh
#
exec > /dev/null
SCRIPTDIR=/usr/bin
mkfifo /tmp/tmpfifo
cd $SCRIPTDIR
./mysqldump -h localhost -u root -pclipper iesa > /tmp/tmpfifo
res=$?
if (test $res -ne 0) then
logger -t mysql -isd ERROR Dump done with errors. Exit status $res
else
logger -t mysql -isd OK Dump done with no errors. Exit status $res
fi
Then I modify Bacula files to run the backup, using the script, to a
fifofile.
In Bacula-Director file:
Job {
Name = "BackupMySQL"
Type = Backup
Client = client-fd
FileSet = "MySQLdb"
Schedule = "WeeklyCycleAfterBackup"
Storage = FifoStorage
Messages = Standard
Pool = MySQLPool
RunBeforeJob = "/etc/bacula/MyScripts/backwithfifo" #this is the script
which dumps the database to a fifofile
Write Bootstrap = "/var/lib/bacula/BackupMySQL.bsr"
FileSet {
Name = "MySQLdb"
Include {
Options {
signature = MD5
readfifo = yes
}
File = /tmp/fifofiles
}
}
Storage {
Name = FifoStorage
Address = xxx.xxx.xxx.xxx
SDPort = 9103
Password = "password"
Device = FifoStorage
Media Type = Fifo
}
In Bacula-Storage file:
Device {
Name = FifoStorage
Media Type = Fifo
Archive Device = /tmp/fifofiles
Label Media = yes
Random Access = no
AutomaticMount = no
RemovableMedia = no
MaximumOpenWait = 60
AlwaysOpen = no
}
When I run the backup job, it results on an error:
31-Oct 10:08 client-dir: RunBefore: mysql[28164]: Volcado realizado
correctamente.Exit status 0
31-Oct 10:08 client-dir: No prior Full backup Job record found.
31-Oct 10:08 client-dir: No prior or suitable Full backup found. Doing FULL
backup.
31-Oct 10:08 client-dir: Start Backup JobId 10063,
Job=BackupMySQL.2008-10-31_10.07.42
31-Oct 10:08 client-sd: BackupMySQL.2008-10-31_10.07.42 Fatal error:
Archive "FifoStorage" requested by DIR could not be opened or does not
exist.
31-Oct 10:08 client-dir: BackupMySQL.2008-10-31_10.07.42 Fatal error:
Storage daemon didn't accept Device "FifoStorage" because:
3925 Device "FifoStorage" could not be opened or does not exist.
31-Oct 10:08 client-dir: BackupMySQL.2008-10-31_10.07.42 Error: Bacula
1.36.3 (22Apr05): 31-Oct-2008 10:08:26
JobId: 10063
Job: BackupMySQL.2008-10-31_10.07.42
Backup Level: Full (upgraded from Incremental)
Client: client-fd
FileSet: "MySQLdb" 2008-10-31 09:59:45
Pool: "MySQLPool"
Storage: "FifoStorage"
Start time: 31-Oct-2008 10:07:44
End time: 31-Oct-2008 10:08:26
FD Files Written: 0
SD Files Written: 0
FD Bytes Written: 0
SD Bytes Written: 0
Rate: 0.0 KB/s
Software Compression: None
Volume name(s):
Volume Session Id: 2
Volume Session Time: 1225443462
Last Volume Bytes: 0
Non-fatal FD errors: 0
SD Errors: 0
FD termination status:
SD termination status:
Termination: *** Backup Error ***
As you can see, the error is "Storage daemon didn't accept Device
FifoStorage because could not be opened or does not exist". I can see the
file fifofile in /tmp/fifofile and I can do a cat but the Storage Daemon
seems can't open the file. I don't know how to configure a backup job for a
database using fifo. Can anyone tell me where is the error?
Thanks a lot
ISABEL
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
