Re: [Bacula-users] error about MySQL-dump file when using bpipe
2016-01-22 06:48:13
I know how bpipe works and my method using script is to work around
an issue with bpipe erroring out with "Error closing stream for
pseudo file" (no idea why, but running the same mysqldump command
from inside script solves this). Contents of the script is really
straight-forward and doesn't change behavior of the dump being sent
to STDOUT:
#!/bin/sh
user=backup
pswd=PASSWORD
if [ "$1" = "-R" ]; then
/usr/bin/mysql --default-character- set =utf8 -u "$user" -p "$pswd"
else
/usr/bin/mysqldump --single-transaction --routines --events --opt
--max_allowed_packet 128M --default-character- set =utf8 --log-error= /var/log/mysql/mysqldump_err .log -u "$user" -p "$pswd" --databases $*
fi
exit 0
BTW, I discovered that the error
"bpipe-fd: Error closing for file /srv/mysqldump.sql" was caused
of the wrong credentials I had in the script. The first error
still remains.
--
Silver
On 22.01.2016 12:55, Heitor Faria
wrote:
Hello Silver,
Hello Silver [2],
bpipe reads a command data that is directed to stdout and
stores in backup with the name you put in the 2nd variable
(fifo path) => I hope is what you are trying to achieve
with your scripts. While in restore Bacula uses the last bpipe
configuration variable (command) to read from stdin and
restore your data with the application of your choice. I never
saw a bpipe usage documentation with scripts, but with
commands directly. E.g.: Plugin =
“bpipe:/mnt/fifo/heitorfaria.sql:mysqldump -u root -ppasswd
–databases heitorfaria:mysql -u root -ppasswd″
The beauty of bpipe is you don't
need local disk space to generate the dumps since fifos
actually don't hold data (it just streams it to an end) and
you may also automate application restore directly to it.
I recorded some videoclasses that
you can find in the same URL post I provided.
Regards,
--
=======================================================================
Heitor Medrado de Faria - LPIC-III | ITIL-F | Bacula Systems Certified Administrator II
========================================================================
|
------------------------------------------------------------------------------
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>
|
- [Bacula-users] error about MySQL-dump file when using bpipe, Silver Salonen
- 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
|
|
|