Re: [Bacula-users] error about MySQL-dump file when using bpipe
2016-01-25 03:48:16
Yeah, so what can we conclude from this now? :)
--
Silver
On 22.01.2016 17:55, Wanderlei Huttel
wrote:
Hi Silver
I've made a test using your script and worked fine!
I'm using bacula 7.4.0.
-
MySQL user has all privileges;
grant
all on *.* to 'user'@'localhost' identified by 'password';
- The directory and file /mnt/fifo/intranet.sql doesn't exists
- Permission of script is 775
##################################################
# FileSet teste bpipe
FileSet {
Name =
"FileSet_Bpipe_Bacula"
Include {
Options {
signature = md5
compression =
gzip
}
Plugin =
"bpipe:/backup/dump_mysql.sql:/usr/local/bin/backup_mysql.sh
intranet:/usr/local/bin/backup_mysql.sh -R"
}
}
##################################################
Backup Log
2016-01-22 13:43:01 bacula-dir JobId 3012: Start Backup JobId 3012, Job=Backup_Bpipe_Bacula.2016-01-22_13.42.59_48
2016-01-22 13:43:01 bacula-dir JobId 3012: Using Device "DiscoLocal1" to write.
2016-01-22 13:43:01 bacula-sd JobId 3012: Volume "Volume-Default-0001" previously written, moving to end of data.
2016-01-22 13:43:01 bacula-sd JobId 3012: Ready to append to end of Volume "Volume-Default-0001" size=35,757,662
2016-01-22 13:43:05 bacula-sd JobId 3012: Elapsed time=00:00:04, Transfer rate=1.680 M Bytes/second
2016-01-22 13:43:05 bacula-sd JobId 3012: Sending spooled attrs to the Director. Despooling 285 bytes ...
2016-01-22 13:43:05 bacula-dir JobId 3012: Bacula bacula-dir 7.4.0 (16Jan16):
Build OS: x86_64-unknown-linux-gnu debian 8.2
JobId: 3012
Job: Backup_Bpipe_Bacula.2016-01-22_13.42.59_48
Backup Level: Full
Client: "srv_bacula-fd" 7.4.0 (16Jan16) x86_64-unknown-linux-gnu,debian,8.2
FileSet: "FileSet_Bpipe_Bacula" 2016-01-22 13:42:59
Pool: "Pool-Default" (From Job resource)
Catalog: "MyCatalog" (From Client resource)
Storage: "StorageLocal1" (From Pool resource)
Scheduled time: 22-Jan-2016 13:42:59
Start time: 22-Jan-2016 13:43:01
End time: 22-Jan-2016 13:43:05
Elapsed time: 4 secs
Priority: 10
FD Files Written: 1
SD Files Written: 1
FD Bytes Written: 6,722,331 (6.722 MB)
SD Bytes Written: 6,722,542 (6.722 MB)
Rate: 1680.6 KB/s
Software Compression: 85.1% 6.7:1
Snapshot/VSS: no
Encryption: no
Accurate: no
Volume name(s): Volume-Default-0001
Volume Session Id: 7
Volume Session Time: 1453470218
Last Volume Bytes: 42,492,736 (42.49 MB)
Non-fatal FD errors: 0
SD Errors: 0
FD termination status: OK
SD termination status: OK
Termination: Backup OK
2016-01-22 13:43:05 bacula-dir JobId 3012: Begin pruning Jobs older than 1 year .
2016-01-22 13:43:05 bacula-dir JobId 3012: No Jobs found to prune.
2016-01-22 13:43:05 bacula-dir JobId 3012: Begin pruning Files.
2016-01-22 13:43:05 bacula-dir JobId 3012: No Files found to prune.
2016-01-22 13:43:05 bacula-dir JobId 3012: End auto prune.
2016-01-22 13:43:05 bacula-dir JobId 3012: shell command: run AfterJob "/etc/bacula/scripts/send_whatsapp.sh "Client=srv_bacula-fd" "JobId=3012" "JobName=Backup_Bpipe_Bacula" "JobBytes=6722331" "JobFiles=1" "Level=Full" "Pool=Pool-Default" "Storage=StorageLocal1" "Status=OK""
2016-01-22 13:43:06 bacula-dir JobId 3012: AfterJob: INFO:yowsup.demos.sendclient.layer:Message sent
Restore Log
2016-01-22 13:44:44 bacula-dir JobId 3013: Start Restore Job Restore_Files.2016-01-22_13.44.42_56
2016-01-22 13:44:44 bacula-dir JobId 3013: Using Device "DiscoLocal1" to read.
2016-01-22 13:44:44 bacula-sd JobId 3013: Ready to read from volume "Volume-Default-0001" on file device "DiscoLocal1" (/mnt/disco_usb).
2016-01-22 13:44:44 bacula-sd JobId 3013: Forward spacing Volume "Volume-Default-0001" to file:block 0:35757662.
2016-01-22 13:44:45 bacula-sd JobId 3013: End of Volume at file 0 on device "DiscoLocal1" (/mnt/disco_usb), Volume "Volume-Default-0001"
2016-01-22 13:44:45 bacula-sd JobId 3013: End of all volumes.
2016-01-22 13:44:45 bacula-sd JobId 3013: Elapsed time=00:00:01, Transfer rate=6.722 M Bytes/second
2016-01-22 13:45:57 bacula-dir JobId 3013: Bacula bacula-dir 7.4.0 (16Jan16):
Build OS: x86_64-unknown-linux-gnu debian 8.2
JobId: 3013
Job: Restore_Files.2016-01-22_13.44.42_56
Restore Client: srv_bacula-fd
Start time: 22-Jan-2016 13:44:44
End time: 22-Jan-2016 13:45:57
Files Expected: 1
Files Restored: 1
Bytes Restored: 45,185,460
Rate: 619.0 KB/s
FD Errors: 0
FD termination status: OK
SD termination status: OK
Termination: Restore OK
2016-01-22 13:45:57 bacula-dir JobId 3013: Begin pruning Jobs older than 1 year .
2016-01-22 13:45:57 bacula-dir JobId 3013: No Jobs found to prune.
2016-01-22 13:45:57 bacula-dir JobId 3013: Begin pruning Files.
2016-01-22 13:45:57 bacula-dir JobId 3013: No Files found to prune.
2016-01-22 13:45:57 bacula-dir JobId 3013: End auto prune.
Best Regards
Wanderlei
|
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140 _______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Re: [Bacula-users] error about MySQL-dump file when using bpipe, (continued)
- Re: [Bacula-users] error about MySQL-dump file when using bpipe, Heitor Faria
- Re: [Bacula-users] error about MySQL-dump file when using bpipe, Silver Salonen
- Re: [Bacula-users] error about MySQL-dump file when using bpipe, Silver Salonen
- Re: [Bacula-users] error about MySQL-dump file when using bpipe, Ana Emília M. Arruda
- Re: [Bacula-users] error about MySQL-dump file when using bpipe, Silver Salonen
- Re: [Bacula-users] error about MySQL-dump file when using bpipe, Ana Emília M. Arruda
- Re: [Bacula-users] error about MySQL-dump file when using bpipe, Heitor Faria
- Re: [Bacula-users] error about MySQL-dump file when using bpipe, Silver Salonen
- Re: [Bacula-users] error about MySQL-dump file when using bpipe, Silver Salonen
- Re: [Bacula-users] error about MySQL-dump file when using bpipe, Wanderlei Huttel
- Re: [Bacula-users] error about MySQL-dump file when using bpipe,
Silver Salonen <=
- Re: [Bacula-users] error about MySQL-dump file when using bpipe, Silver Salonen
- Re: [Bacula-users] error about MySQL-dump file when using bpipe, Wanderlei Huttel
- Re: [Bacula-users] error about MySQL-dump file when using bpipe, Silver Salonen
- Re: [Bacula-users] error about MySQL-dump file when using bpipe, Kern Sibbald
- Re: [Bacula-users] error about MySQL-dump file when using bpipe, Ana Emília M. Arruda
- Re: [Bacula-users] error about MySQL-dump file when using bpipe, Silver Salonen
|
|
|