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
32 exec @SQL_BINDIR@/pg_dump -U $2 $1 >$1.sql
34 echo ".dump" | @SQL_BINDIR@/sqlite3 $1.db >$1.sql
39 # To read back a MySQL database use:
41 # rm -f @SQL_BINDIR@/../var/bacula/*
44 # To read back a SQLite database use:
47 # sqlite bacula.db <bacula.sql
49 # To read back a PostgreSQL database use:
53 # psql bacula <bacula.sql