3 REM This script dumps your Bacula catalog in ASCII format
\r
4 REM It works for MySQL, SQLite, and PostgreSQL
\r
6 REM %1 is the name of the database to be backed up and the name
\r
7 REM of the output file (default = bacula
\r
8 REM %2 is the user name with which to access the database
\r
9 REM (default = bacula).
\r
10 REM %3 is the password with which to access the database or "" if no password
\r
16 DEL /f "@working_dir_cmd@\%1.sql" 2>nul
\r
20 IF NOT "%3"=="" SET PGPASSWORD=--password=%3
\r
21 "@SQL_BINDIR@\pg_dump" -c -U %2 %1 >"@working_dir_cmd@\%1.sql"
\r
25 REM To read back a MySQL database use:
\r
26 REM cd @working_dir_cmd@
\r
27 REM rd /s /q @SQL_BINDIR@\..\data\bacula
\r
28 REM mysql < bacula.sql
\r
30 REM To read back a SQLite database use:
\r
31 REM cd @working_dir_cmd@
\r
32 REM del /f bacula.db
\r
33 REM sqlite bacula.db < bacula.sql
\r
35 REM To read back a PostgreSQL database use:
\r
36 REM cd @working_dir_cmd@
\r
39 REM psql bacula < bacula.sql
\r