3 REM This script dumps your Bacula catalog in ASCII format
4 REM It works for MySQL, SQLite, and PostgreSQL
6 REM %1 is the name of the database to be backed up and the name
7 REM of the output file (default = bacula
8 REM %2 is the user name with which to access the database
9 REM (default = bacula).
10 REM %3 is the password with which to access the database or "" if no password
16 DEL /f "@working_dir_cmd@\%1.sql" 2>nul
18 ECHO .dump | "@bin_dir_cmd@\sqlite3" "@working_dir_cmd@\%1.db" > "@working_dir_cmd@\%1.sql"
22 REM To read back a MySQL database use:
23 REM cd @working_dir_cmd@
24 REM rd /s /q @SQL_BINDIR@\..\data\bacula
25 REM mysql < bacula.sql
27 REM To read back a SQLite database use:
28 REM cd @working_dir_cmd@
30 REM sqlite bacula.db < bacula.sql
32 REM To read back a PostgreSQL database use:
33 REM cd @working_dir_cmd@
36 REM psql bacula < bacula.sql