Hi,
On 9/27/2006 9:29 AM, Diego wrote:
> Hi I try various ways for backup a mysql. I think the best is do a
> mysqldump (run before job) and backup the sql file (Fileset = { File =
> tmp/mydatabase.sql } ) but I have a lot of problems with permissions
> with any command. Where the command "run before job" is executed?in the
> director host (bacula-director)?or in the client host (bacula-fd)?
A Run Before Job command is executed on the director machine, a Client
Run Before Job command on the FD machine.
> this is the command I try:
>
> "mysqldump -h localhost -u zimbra --all-databases
> --socket=/opt/zimbra/db/mysql.sock --password=7glTIK_2QcuMJ_wgQVv8Pmxz >
> mydatabase.sql"
Thanks for the password :-)
You should change it NOW.
> Any suggestions?
Yes - Read the manual for mysqldump. There are some options you should
consider for good results. Think about locking, key disabling,
--add-drop-tables for example. This depends on your restore needs, though.
Make sure the command you execute results in the action you want. Run it
from a shell, as the user Bacula would run it as.
Make sure there are no errors. For example, I could imagine that
--all-databases might conflict with giving a limited account to use.
Verify that the database dump actually contains all the info you need.
And, last not least, do you have any error messages?
Arno
> Thanks
> --
> By Diego... >8-P
>
>
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
--
IT-Service Lehmann [EMAIL PROTECTED]
Arno Lehmann http://www.its-lehmann.de
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
