Hello again,
Incase anyone else ever needs it, this line will create a full sql dump
of all databses from the local SQL server:
RunBeforeJob = "cmd /k mysqldump -uUSER
-pPASS --all-databases -r C://DIR//FILE.sql"
nb. you must create an empty text file eg. FILE.sql in the save
location, this will be overwritten each time the command is run.
Thanks for all your help.
Dan
[EMAIL PROTECTED] wrote:
Thanks for the hellp guys!
Alan Brown wrote:
mysqlhotcopy can be used to copy out the tables in binary format if that's
really wanted, but my experience is that the mysqldump table compresses
_extremely_ well on tape.
Thanks Alan, I will look into that also. Though the db is not huge, and my boss
and I agree with Dan, that text would be preferable. It just means that if all
else fails the information is still there to be read.
Cesare Montresor wrote:
I have done some test fews days ago, try this use this shape:
Job
{
...
ClientRunBeforeJob = "cmd /k c:\\programmi\\bacula\\scripts\\before.bat"
...
}
Thanks Cesare, it still doesn't run the script though :(
The really odd thing is that I have a delete script that works fine
when Run Before or After the Job. Using the following format
(RunAfterJob = "e:/backup/delete-bacula-catalog.bat") So I am pretty
sure that its an issue with Bacula running xcopy which I am not using
anymore anyway.
Hopefully, mysqldump will solve all :D
Thanks again, I'll post a solution once I get time to make one. I got
swamped yesterday, and haven't even looked at the man yet!
Dan
------------------------------------------------------------------------
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
