17.01.2014 10:46, Vladimir Skubriev ?????:
Hi!
I put thing's in order and accidentally deleted mysql database(current
running) with bacula catalog and mysql service database.
But I have backups of bacula catalog database with mysqldump.
But this mysql dump in bacula volumes (
BaculaCatalog0001-0044.
It is possible to extract mysql dump sql file from bacula volume,
without running mysql bacula database ?
Here's how my backup work:
in pre script i do mysqdump
bacula did backup this dump to one volume once with FULL LEVEL
then in post script i delete this dump.
Thank you very much.
OK. I restored all the same from other old arhive of mysql dir and
extract latest backup from Volume as following:
*
# bls -j -V BaculaCatalog0045 /mnt/bigraid/backups/bacula
bls: butil.c:287 Using device: "/mnt/bigraid/backups/bacula" for reading.
17-Jan 11:44 bls JobId 0: Ready to read from volume "BaculaCatalog0045"
on device "BaculaBackupStorage" (/mnt/bigraid/backups/bacula).
Volume Record: File:blk=0:213 SessId=4 SessTime=1389795845 JobId=0
DataLen=178
Begin Job Session Record: File:blk=0:64725 SessId=4 SessTime=1389795845
JobId=500
Job=BackupBaculaCatalog.2014-01-16_06.30.00_05 Date=16-Jan-2014
06:31:50 Level=F Type=B
End Job Session Record: File:blk=0:3256011665 SessId=4
SessTime=1389795845 JobId=500
Date=16-Jan-2014 06:34:27 Level=F Type=B Files=1 Bytes=3,253,598,370
Errors=0 Status=T
17-Jan 11:45 bls JobId 0: End of Volume at file 0 on device
"BaculaBackupStorage" (/mnt/bigraid/backups/bacula), Volume
"BaculaCatalog0045"
17-Jan 11:45 bls JobId 0: End of all volumes.
Create bsr file! From data of previous bls command
restore-bacula-catalog.bsr:
Volume = BaculaCatalog0045
VolSessionId = 4
VolSessionTime = 1389795845
# cd /mnt/bigraid/backups/bacula
# bextract -b restore-bacula-catalog.bsr -V
/mnt/bigraid/backups/bacula/BaculaCatalog0045
/mnt/bigraid/backups/bacula /mnt/bigraid/
*Maybe will work without* -V /mnt/bigraid/backups/bacula/BaculaCatalog0045
# mysql -uroot -pSECRETPASSWORD bacula <
/mnt/bigraid/var/lib/bacula/bacula.sql*
I don't understand why I need to put always
'*/mnt/bigraid/backups/bacula*' ?
--
--
Faithfully yours,
Vladimir Skubriev
------------------------------------------------------------------------------
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today.
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
