This is what you said Arno Lehmann
> 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?As the original poster is not concerned with passwords, check out: http://www.worldcommunity.com/opensource/utilities/mysql_backup.html It is a configurable perl script that can be run before a backup to dump databases to disk. ------------------------------------------------------------------------- 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
