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
18 if test xsqlite = x@DB_NAME@ ; then
19 echo ".dump" | ${BINDIR}/sqlite $1.db >$1.sql
21 if test xmysql = x@DB_NAME@ ; then
22 if test $# -gt 2; then
23 MYSQLPASSWORD=" --password=$3"
27 ${BINDIR}/mysqldump -u $2$MYSQLPASSWORD -f --opt $1 >$1.sql
29 if test xpostgresql = x@DB_NAME@ ; then
30 if test $# -gt 2; then
34 exec ${BINDIR}/pg_dump -c -U $2 $1 >$1.sql
36 echo ".dump" | ${BINDIR}/sqlite3 $1.db >$1.sql
41 # To read back a MySQL database use:
43 # rm -f ${BINDIR}/../var/bacula/*
46 # To read back a SQLite database use:
49 # sqlite bacula.db <bacula.sql
51 # To read back a PostgreSQL database use:
55 # psql bacula <bacula.sql