3 # This script dumps your Bacula catalog in ASCII format
4 # It works for MySQL, SQLite, and PostgreSQL
6 # $1 is the name of the database to be backed up and the name
7 # of the output file (default = bacula).
8 # $2 is the user name with which to access the database
10 # $3 is the password with which to access the database or "" if no password
16 if test xsqlite = x@DB_NAME@ ; then
17 echo ".dump" | @SQL_BINDIR@/sqlite $1.db >$1.sql
19 if test xmysql = x@DB_NAME@ ; then
20 if test $# -gt 2; then
21 MYSQLPASSWORD=" --password=$3"
25 @SQL_BINDIR@/mysqldump -u $2$MYSQLPASSWORD -f --opt $1 >$1.sql
27 if test xpostgresql = x@DB_NAME@ ; then
28 if test $# -gt 2; then
31 exec @SQL_BINDIR@/pg_dump -U $2 $1 >$1.sql
33 echo ".dump" | @SQL_BINDIR@/sqlite3 $1.db >$1.sql
38 # To read back a MySQL database use:
40 # rm -f @SQL_BINDIR@/../var/bacula/*
43 # To read back a SQLite database use:
46 # sqlite bacula.db <bacula.sql
48 # To read back a PostgreSQL database use:
51 # psql bacula <bacula.sql