Backup com bacula [RESOLVIDO]

radolpho
(usa Ubuntu)

Enviado em 28/08/2013 - 16:24h

Olá pessoal. estou usando o bacula para fazer backup do meu banco de dados.

No entanto ele não roda o comando mysqldump no clientRunBefore, dá uma erro, mas se eu rodar o mesmo comando direto no servidor ele funciona. Segue o erro do bacula:

28-Aug 16:19 bacula-dir JobId 122: Start Backup JobId 122, Job=tatooine-fd.2013-08-28_16.19.22_00
28-Aug 16:19 bacula-dir JobId 122: Using Device "File"
28-Aug 16:16 tatooine-fd JobId 122: DIR and FD clocks differ by -170 seconds, FD automatically compensating.
28-Aug 16:16 tatooine-fd JobId 122: shell command: run ClientRunBeforeJob "mysqldump -h localhost --events -u root -p123 --all-databases > /home/cliente/bcks/bckmy/backup_meuBanco.sql"
28-Aug 16:16 tatooine-fd JobId 122: ClientRunBeforeJob: Usage: mysqldump [OPTIONS] database [tables]
28-Aug 16:16 tatooine-fd JobId 122: ClientRunBeforeJob: OR mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
28-Aug 16:16 tatooine-fd JobId 122: ClientRunBeforeJob: OR mysqldump [OPTIONS] --all-databases [OPTIONS]
28-Aug 16:16 tatooine-fd JobId 122: ClientRunBeforeJob: For more options, use mysqldump --help
28-Aug 16:16 tatooine-fd JobId 122: Error: Runscript: ClientRunBeforeJob returned non-zero status=1. ERR=Child exited with code 1
28-Aug 16:19 bacula-dir JobId 122: Fatal error: Bad response to ClientRunBeforeJob command: wanted 2000 OK RunBefore
, got 2905 Bad RunBeforeJob command.

28-Aug 16:19 bacula-dir JobId 122: Fatal error: Client "tatooine-fd" RunScript failed.
28-Aug 16:19 bacula-dir JobId 122: Error: Bacula bacula-dir 5.2.5 (26Jan12):
Build OS: x86_64-pc-linux-gnu ubuntu 12.04
JobId: 122
Job: tatooine-fd.2013-08-28_16.19.22_00
Backup Level: Incremental, since=2013-08-23 15:45:39
Client: "tatooine-fd" 5.2.5 (26Jan12) x86_64-pc-linux-gnu,ubuntu,12.04
FileSet: "fileset-tatooine" 2013-08-21 20:59:40
Pool: "file-Daily" (From Job resource)
Catalog: "catalog" (From Client resource)
Storage: "armazenador-sd" (From Job resource)
Scheduled time: 28-Aug-2013 16:19:21
Start time: 28-Aug-2013 16:19:24
End time: 28-Aug-2013 16:19:25
Elapsed time: 1 sec
Priority: 10
FD Files Written: 0
SD Files Written: 0
FD Bytes Written: 0 (0 B)
SD Bytes Written: 0 (0 B)
Rate: 0.0 KB/s
Software Compression: None
VSS: no
Encryption: no
Accurate: no
Volume name(s):
Volume Session Id: 9
Volume Session Time: 1377706792
Last Volume Bytes: 2,817,307,270 (2.817 GB)
Non-fatal FD errors: 2
SD Errors: 0
FD termination status: Error
SD termination status: OK
Termination: *** Backup Error ***


O que será que está errado?

radolpho
(usa Ubuntu)

Enviado em 29/08/2013 - 14:28h

Olá galera. Consegui resolver o problema.
É só trocar o sinal de > pela opção -r (Saída direta para um determinado arquivo).
mysqldump -h localhost --events -u root -p123 --all-databases -r /home/cliente/bcks/bckmy/backup_meuBanco.sql

Resolvido o problema.