make_catalog_backup.cmd
 add:  set working_dir=c:\program files\bacula\var\Work
change: "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqldump" -u %2 %MYSQLPASSWORD% -f --opt %1 > "*%working_dir%*\%1.sql"

delete_catalog_backup.cmd
 add:  set working_dir=c:\program files\bacula\var\Work
 change:  DEL /f "*%working_dir%*\bacula.sql"

Brian Debelius wrote:
create_database.cmd
  add:  SET MYSQLUSER=root
  add:  SET MYSQLPASS=mysqlpassword
change: "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql" *-u %MYSQLUSER% --password=%MYSQLPASS%* %* -e "CREATE DATABASE bacula;"

drop_database.cmd
  add:  SET MYSQLUSER=root
  add:  SET MYSQLPASS=mysqlpassword
change: "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql" *-u %MYSQLUSER% --password=%MYSQLPASS%* %* -f -e "DROP DATABASE bacula;"

grant_privileges.cmd
  add:  SET MYSQLUSER=root
  add:  SET MYSQLPASS=mysqlpassword
change: "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql" *-u %MYSQLUSER% --password=%MYSQLPASS%* -f %* < "C:\Program Files\Bacula\bin\grant_mysql_privileges.sql"

grant_mysql_privileges.sql
change: grant all privileges on bacula.* to [EMAIL PROTECTED] *identified by 'mysqlpassword';* change: grant all privileges on bacula.* to bacula@"%" *identified by 'mysqlpassword';

*make_tables.cmd
  add:  SET MYSQLUSER=root
  add:  SET MYSQLPASS=mysqlpassword
change: "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql" *-u %MYSQLUSER% --password=%MYSQLPASS%* -f %* < "C:\Program Files\Bacula\bin\make_mysql_tables.sql"

drop_tables.cmd
  add:  SET MYSQLUSER=root
  add:  SET MYSQLPASS=mysqlpassword
change: "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql" *-u %MYSQLUSER% --password=%MYSQLPASS%* %* < "C:\Program Files\Bacula\bin\drop_mysql_tables.sql"

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to