Hello all,
I managed to backup and restore a mysqll dump with FIFO. The trick was to use
the screen command and ReadFifo=yes on FileSet:
screen -d -m -S mysqldump -t mysqldump su -s /bin/bash -c "-u root -p123456
test > /tmp/bacula.sql"
Despite of the file being copied correctly I keep receiving this scary message
on backup log:
Cannot open "/tmp/bacula.sql": ERR=Interrupted system call.
Any hints?
==============================================================================
Heitor Medrado de Faria - LPIC-III | ITIL-F
04 a 15 de maio: Novo Treinamento Telepresencial Bacula:
http://www.bacula.com.br/?p=2174
61 8268-4220
Site: www.bacula.com.br | Facebook: heitor.faria | Gtalk: [email protected]
===============================================================================
----- Mensagem original -----
> De: "Heitor Faria" <[email protected]>
> Para: "Kern Sibbald" <[email protected]>
> Cc: "bacula-users" <[email protected]>
> Enviadas: Sábado, 28 de fevereiro de 2015 11:19:20
> Assunto: Re: [Bacula-users] FIFO Backup Questions
> > The answer to #1 is given in your #2 -- i.e. it is complicated, and if you
> > do
> > not have a program on the other end of a FIFO doing the right thing
> > (read/write), Bacula will stall. FIFOs have their place, but you have to
> > understand them very well to make them work or debug them.
>
> Hello Kern! Copy operations seems to trigger the end o FIFO, so I suppose
> Bacula read operation will do the trick.
> I will keep researching. Maybe posting on a Shell Script list will be more
> fruitful.
> Regards,
> ==============================================================================
> Heitor Medrado de Faria - LPIC-III | ITIL-F
> 02 a 13 de Março - Novo Treinamento Telepresencial Bacula:
> http://www.bacula.com.br/?p=2174
> 61 8268-4220
> Site: www.bacula.com.br | Facebook: heitor.faria | Gtalk:
> [email protected]
> ===============================================================================
> > On 27.02.2015 22:59, Heitor Faria wrote:
>
> > > Dear Bacula Users,
> >
>
> > > 1. Why FIFO isn't more popular for database dumps backups? Is there any
> > > drawback?
> >
>
> > > 2. I inserted RedFifo=yes on FileSet Options and configured a simple
> > > RunBeforeJob script (below) to test FIFO backup, but the backup job
> > > stalls
> > > waitng for script termination. Am I missing something?
> >
>
> > > [ -p /tmp/tubo ] ||mkfifo /tmp/tubo
> >
>
> > > ls -l > /tmp/tubo
> >
>
> > > Regards,
> >
>
> > > ==============================================================================
> >
>
> > > Heitor Medrado de Faria - LPIC-III | ITIL-F
> >
>
> > > 02 a 13 de Março - Novo Treinamento Telepresencial Bacula:
> > > http://www.bacula.com.br/?p=2174
> >
>
> > > 61 8268-4220
> >
>
> > > Site: www.bacula.com.br | Facebook: heitor.faria | Gtalk:
> > > [email protected]
> >
>
> > > ===============================================================================
> >
>
> > > ------------------------------------------------------------------------------
> >
>
> > > Dive into the World of Parallel Programming The Go Parallel Website,
> > > sponsored
> >
>
> > > by Intel and developed in partnership with Slashdot Media, is your hub
> > > for
> > > all
> >
>
> > > things parallel software development, from weekly thought leadership
> > > blogs
> > > to
> >
>
> > > news, videos, case studies, tutorials and more. Take a look and join the
> >
>
> > > conversation now. http://goparallel.sourceforge.net/
> >
>
> > > _______________________________________________
> >
>
> > > Bacula-users mailing list [email protected]
> > > https://lists.sourceforge.net/lists/listinfo/bacula-users
> >
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming The Go Parallel Website,
> sponsored
> by Intel and developed in partnership with Slashdot Media, is your hub for
> all
> things parallel software development, from weekly thought leadership blogs to
> news, videos, case studies, tutorials and more. Take a look and join the
> conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> Bacula-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
