RefDB

Update of /cvsroot/refdb/refdb/scripts
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv17912

Modified Files:
	refdb-backup refdb-restore 
Log Message:
Changed archive format from 'zip' to 'tar.gz'.


Index: refdb-backup
===================================================================
RCS file: /cvsroot/refdb/refdb/scripts/refdb-backup,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -U2 -r1.2 -r1.3
--- refdb-backup	30 Jan 2005 10:31:25 -0000	1.2
+++ refdb-backup	30 Jan 2005 13:39:34 -0000	1.3
@@ -14,6 +14,6 @@
 notes_backup="xnotes.xml"
 styles_directory="styles"
-logfile="log"
-zipfile="refdb_backup_`date '+%Y%m%d_%H%M'`"
+logfile="log_backup"
+archive="refdb_backup_`date '+%Y%m%d_%H%M'`.tar.gz"
 
 
@@ -92,4 +92,5 @@
 	*    ) endScript "No format selected." "failed";;
 esac
+echo ; echo "References storage format: ${format}." ; echo
 
 # Record date/time of backup
@@ -146,5 +147,6 @@
 echo "Compressing to archive"
 echo -n "  Writing archive ... "
-find . -name '*' | zip ${zipfile} -@ &> /dev/null
+#find . -name '*' | zip ${archive} -@ &> /dev/null
+tar -czf ${archive} *
 report $?
 echo -n "  Deleting backup files ... "
@@ -157,4 +159,4 @@
 
 # Finished
-echo ; echo "Backup archive: '${zipfile}.zip'."
+echo ; echo "Backup archive: '${archive}'."
 endScript "Backup finished." "succeeded"

Index: refdb-restore
===================================================================
RCS file: /cvsroot/refdb/refdb/scripts/refdb-restore,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -U2 -r1.2 -r1.3
--- refdb-restore	30 Jan 2005 10:31:25 -0000	1.2
+++ refdb-restore	30 Jan 2005 13:39:34 -0000	1.3
@@ -17,5 +17,5 @@
 notes_backup="xnotes.xml"
 styles_directory="styles"
-logfile="log"
+logfile="log_restore"
 
 
@@ -70,5 +70,5 @@
 	db=$2
 	base=$3
-	filelist=`unzip -l $1 | sed -e 's/ \+/ /g' | cut -d ' ' -f 5 | grep -v '^$' | sed -e '1,2d' | grep -v "/$" | grep "^db_"`
+	filelist=`tar -tzf $1 | grep -v "/$" | grep "^db_"`
 	[ `echo "${filelist}" | grep "^db_${db}/${references_backup}.xml"` ] \
 		&& extension="xml"
@@ -105,7 +105,8 @@
 # - must exist and be readable
 [ -r $1 ] || endScript "Cannot read backup archive '$1'." "failed"
-# - must be valid archive
-unzip -t $1 &> /dev/null
-[ $? -ne 0 ] && endScript "'$1' is not a valid zip archive." "failed"
+# - must be valid archive (this test is a bit crude - just list
+#   archive contents and check exit status)
+tar -tzf $1 &> /dev/null
+[ $? -ne 0 ] && endScript "'$1' is not a valid archive." "failed"
 
 # Informational message
@@ -119,5 +120,5 @@
 
 # Cycle through databases in turn and restore references and notes
-for dbdir in `unzip -l $1 | sed -e 's/ \+/ /g' | cut -d ' ' -f 5 | grep -v '^$' | sed -e '1,2d' | grep "/$"` ; do
+for dbdir in `tar -tzf $1 | grep "/$"` ; do
 	# get db name
 	if [ ${dbdir} != "styles/" ] ; then
@@ -126,5 +127,4 @@
 		echo "Restoring database: ${db}" | tee -a ${logfile}
 		# restore references
-		#reffile="db_${db}/${references_backup}"
 		reffile=`get_filename $1 ${db} ${references_backup}`
 		echo "  Restore references" | tee -a ${logfile}
@@ -132,5 +132,5 @@
 		echo -n "    Extracting temporary file ... " | tee -a ${logfile}
 		echo "" >> ${logfile}
-		unzip $1 ${reffile} >> ${logfile}
+		tar -xzf $1 ${reffile} >> ${logfile}
 		report $?
 		# - create database
@@ -153,5 +153,5 @@
 		echo -n "    Extracting temporary file ... " | tee -a ${logfile}
 		echo "" >> ${logfile}
-		unzip $1 ${notefile} >> ${logfile}
+		tar -xzf $1 ${notefile} >> ${logfile}
 		report $?
 		# - add notes
@@ -172,9 +172,9 @@
 # Restore styles
 echo "Restoring styles" | tee -a ${logfile}
-for stylefile in `unzip -l $1 | sed -e 's/ \+/ /g' | cut -d ' ' -f 5 | grep -v '^$' | sed -e '1,2d' | grep "^styles/[[:print:]]\+"` ; do
+for stylefile in `tar -tzf $1 | grep "^styles/[[:print:]]\+"` ; do
 	# extract style file
 	echo -n "  Extracting style: " | tee -a ${logfile}
 	echo "" >> ${logfile}
-	unzip $1 ${stylefile} >> ${logfile}
+	tar -xzf $1 ${stylefile} >> ${logfile}
 	if [ $? -eq 0 ] ; then
 		# extract style name

Update of /cvsroot/refdb/refdb/scripts
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv29129

Added Files:
	refdb-backup refdb-restore 
Log Message:
Initial checkin of scripts 'refdb-backup' and 'refdb-restore'.


--- NEW FILE ---
#!/bin/sh

# File: refdb-backup

# Author: David Nebauer

# History: 2004-11-28 Created

# Purpose: Backups references, notes and styles


# VARIABLES
references_backup="references.ris"
notes_backup="xnotes.xml"
styles_directory="styles"
logfile="log"
zipfile="refdb_backup_`date '+%Y%m%d_%H%M'`"


# PROCEDURES

# Report success of operation
report () {
	if [ $1 -eq 0 ] ; then
		if [ "$2" = "log" ] ; then
			echo "OK." | tee -a ${logfile}
		else
			echo "OK."
		fi
	else
		if [ "$2" = "log" ] ; then
			echo "Failed." | tee -a ${logfile}
		else
			echo "Failed."
		fi
	fi
}
# Report failure and abort
endScript () {
	echo ; echo "$1"
	echo ; echo "refdb backup $2."
	echo "`basename $0` is finished."
	if [ "$2" = "succeeded" ] ; then
		# Single tone indicates success
		echo -ne "\a"
		exit 0
	else
		# Double tone indicates failure
		echo -ne "\a" ; sleep 1s ; echo -ne "\a"
		exit 1
	fi
}
# Show usage
displayUsage () {
	echo "`basename $0`: Backs up RefDB data."
	echo
	echo "Usage: `basename $0`"
	echo
	echo "Backs up references, notes and styles from RefDB."
	echo "Must be run in an empty directory."
}


# MAIN

# Check parameters
[ $# -gt 1 ] \
		&& echo "Invalid parameters.  Try '`basename $0` -h'." \
		&& exit 1
[ $# -eq 1 ] && case $1 in
	-h | --help ) displayUsage ; exit 0;;
	* ) echo "Invalid parameter. Try '`basename $0` -h'." ; exit 1;;
esac

# Must be run in empty directory
if [ `ls | grep -v total | wc -l` -ne 0 ] ; then
	echo ; echo "This directory is not empty."
	echo "'`basename $0`' must be run from an empty directory."
	endScript "Aborted." "failed"
fi

# Informational message
echo "`basename $0` is running..." ; echo

# Record date/time of backup
echo "RefDB backup performed by '`basename $0`'." > ${logfile}
echo "Performed: `date '+%Y-%m-%d, %H:%M:%S'`." >> ${logfile}
echo "--------------------------------------------------------" >> ${logfile}

# Cycle through databases in turn and backup references and notes
for db in `refdba -C listdb | cut --delimiter=' ' --fields=1` ; do
	echo "Processing database: ${db}" | tee -a ${logfile}
	dirname="db_${db}"
	echo -n "  Creating subdirectory '${dirname}' ... " | tee -a ${logfile}
	mkdir ${dirname} &> /dev/null
	report $? log
	# dump references
	reffile="${dirname}/${references_backup}"
	echo -n "  Backing up references ... " | tee -a ${logfile}
	refdbc -C getref -d ${db} -t ris -o ${reffile} ":ID:>0" &> /dev/null
	report $? log
	# dump notes
	notefile="${dirname}/${notes_backup}"
	echo -n "  Backing up notes ... " | tee -a ${logfile}
	refdbc -C getnote -d ${db} -t xnote -o ${notefile} ":NID:>0" \
			&> /dev/null
	report $? log
done

# Cycle through styles in turn and back them up
echo "Processing styles" | tee -a ${logfile}
echo -n "  Creating styles directory '${styles_directory}' ... " \
		| tee -a ${logfile}
mkdir ${styles_directory} &> /dev/null
report $? log
for style in `refdba -C liststyle` ; do
	echo -n "  Backing up style: ${style} ... " | tee -a ${logfile}
	# remove terminal period from file name if present
	if [ `echo ${style} | grep "\.$" | wc -l` -eq 1 ] ; then
		stylefile=${style%*.}
	else
		stylefile=${style}
	fi
	stylefile="${styles_directory}/${stylefile}.xml"
	refdba -C getstyle -o ${stylefile} ${style} &> /dev/null
	report $? log
done

# Now done
echo "--------------------------------------------------------" >> ${logfile}
echo "Written log file: ${logfile}."

# Zip files
echo "Compressing to archive"
echo -n "  Writing archive ... "
find . -name '*' | zip ${zipfile} -@ &> /dev/null
report $?
echo -n "  Deleting backup files ... "
for file in `ls -1  | sed -e 's/ \+/ /g' | cut -d ' ' -f 8 | grep -v '^$'` ; do
	[ `echo ${file} | grep "^refdb_backup" | wc -l` -ne 1 ] \
			&& rm -fr ${file} &> /dev/null
done
echo "OK."

# Finished
echo ; echo "Backup archive: '${zipfile}.zip'."
endScript "Backup finished." "succeeded"

--- NEW FILE ---
#!/bin/sh

# File: refdb-backup

# Author: David Nebauer

# History: 2004-11-28 Created
#          2005-01-27 Delete directories when done

# Purpose: Restores references, notes and styles

# Parameter: 1 - backup archive


# VARIABLES
references_backup="references.ris"
notes_backup="xnotes.xml"
styles_directory="styles"
logfile="log"


# PROCEDURES

# Report success of operation
report () {
	if [ $1 -eq 0 ] ; then
		echo "OK." | tee -a ${logfile}
	else
		echo "Failed." | tee -a ${logfile}
	fi
}
# Report failure and abort
endScript () {
	echo ; echo "$1"
	echo ; echo "refdb restore $2."
	echo "`basename $0` is finished."
	if [ "$2" = "succeeded" ] ; then
		# Single tone indicates success
		echo -ne "\a"
		exit 0
	else
		# Double tone indicates failure
		echo -ne "\a" ; sleep 1s ; echo -ne "\a"
		exit 1
	fi
}
# Show usage
displayUsage () {
	echo "`basename $0`: Restores RefDb data from backup."
	echo
	echo "Usage: `basename $0` <backup_archive>"
	echo
	echo "Restores references, notes and styles from backup archive."
	echo "Must be archive created by 'refdb-backup' utility."
}


# MAIN

# Check parameters
[ $# -ne 1 ] \
		&& echo "Invalid parameters.  Try '`basename $0` -h'." \
		&& exit 1
[ $# -eq 1 ] && case $1 in
	-h | --help ) displayUsage ; exit 0;;
esac

# Run tests on archive
# - must exist and be readable
[ -r $1 ] || endScript "Cannot read backup archive '$1'." "failed"
# - must be valid archive
unzip -t $1 &> /dev/null
[ $? -ne 0 ] && endScript "'$1' is not a valid zip archive." "failed"

# Informational message
echo "`basename $0` is running..." ; echo

# Record date/time of backup
echo "RefDB restore performed by '`basename $0`'." > ${logfile}
echo "Performed: `date '+%Y-%m-%d, %H:%M:%S'`." >> ${logfile}
echo "Backup archive: '$1'." >> ${logfile}
echo "--------------------------------------------------------" >> ${logfile}

# Cycle through databases in turn and restore references and notes
for dbdir in `unzip -l $1 | sed -e 's/ \+/ /g' | cut -d ' ' -f 5 | grep -v '^$' | sed -e '1,2d' | grep "/$"` ; do
	# get db name
	if [ ${dbdir} != "styles/" ] ; then
		db=${dbdir##db_}  # remove prefix
		db=${db%%/}  # remove trailing slash
		echo "Restoring database: ${db}" | tee -a ${logfile}
		# restore references
		reffile="db_${db}/${references_backup}"
		echo "  Restore references" | tee -a ${logfile}
		# - extract file
		echo -n "    Extracting temporary file ... " | tee -a ${logfile}
		echo "" >> ${logfile}
		unzip $1 ${reffile} >> ${logfile}
		report $?
		# - create database
		echo -n "    Create database ... " | tee -a ${logfile}
		refdba -C createdb ${db} >> ${logfile}
		report $?
		# - add references
		echo -n "    Adding references ... " | tee -a ${logfile}
		refdbc -C addref -d ${db} -t ris ${reffile} >> ${logfile}
		report $?
		# - delete file
		echo -n "    Deleting temporary file ... " | tee -a ${logfile}
		rm -f ${reffile}
		report $?
		# restore notes
		notefile="db_${db}/${notes_backup}"
		echo "  Restore notes" | tee -a ${logfile}
		# - extract file
		echo -n "    Extracting temporary file ... " | tee -a ${logfile}
		echo "" >> ${logfile}
		unzip $1 ${notefile} >> ${logfile}
		report $?
		# - add notes
		echo -n "    Adding notes ... " | tee -a ${logfile}
		refdbc -C addnote -d ${db} ${notefile} >> ${logfile}
		report $?
		# - delete file
		echo -n "    Deleting temporary file ... " | tee -a ${logfile}
		rm -f ${notefile}
		report $?
		# delete database directory
		echo -n "  Deleting temporary db directory ... " | tee -a ${logfile}
		rmdir db_${db}
		report $?
	fi
done

# Restore styles
echo "Restoring styles" | tee -a ${logfile}
for stylefile in `unzip -l $1 | sed -e 's/ \+/ /g' | cut -d ' ' -f 5 | grep -v '^$' | sed -e '1,2d' | grep "^styles/[[:print:]]\+"` ; do
	# extract style file
	echo -n "  Extracting style: " | tee -a ${logfile}
	echo "" >> ${logfile}
	unzip $1 ${stylefile} >> ${logfile}
	if [ $? -eq 0 ] ; then
		# extract style name
		stylename=`grep "^[[:print:]]*<STYLENAME>" ${stylefile}`
		stylename=${stylename#[[:print:]]*<STYLENAME>}
		stylename=${stylename%<\/STYLENAME>}
		echo ${stylename}
		# add style
		echo -n "    Adding style ... " | tee -a ${logfile}
		refdba -C addstyle ${stylefile} >> ${logfile}
		report $?
		echo -n "    Deleting temporary file ... " | tee -a ${logfile}
		rm -f ${stylefile}
		report $?
	else
		report 1
	fi
done
# delete styles directory
echo -n "  Deleting styles directory ... " | tee -a ${logfile}
rmdir styles
report $?

# Now done
echo "--------------------------------------------------------" >> ${logfile}
echo "Written log file: ${logfile}."

# Finished
endScript "Restore finished." "succeeded"

Update of /cvsroot/refdb/refdb/scripts
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv5893

Modified Files:
	refdb-backup refdb-restore 
Log Message:
Backup script now gives choice of 'ris' or 'risx' backup formats.  Restore script detects format and handles accordingly.  Log file no longer deleted after backup.


Index: refdb-backup
===================================================================
RCS file: /cvsroot/refdb/refdb/scripts/refdb-backup,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -U2 -r1.1 -r1.2
--- refdb-backup	30 Jan 2005 01:09:09 -0000	1.1
+++ refdb-backup	30 Jan 2005 10:31:25 -0000	1.2
@@ -11,5 +11,5 @@
 
 # VARIABLES
-references_backup="references.ris"
+references_backup="references"
 notes_backup="xnotes.xml"
 styles_directory="styles"
@@ -83,7 +83,18 @@
 echo "`basename $0` is running..." ; echo
 
+# Select storage format
+old_PS3=${PS3}
+PS3="Select the storage format for references: "
+select format in "ris" "risx" ; do break ; done
+case ${format} in
+	ris  ) extension="ris";;
+	risx ) extension="xml";;
+	*    ) endScript "No format selected." "failed";;
+esac
+
 # Record date/time of backup
 echo "RefDB backup performed by '`basename $0`'." > ${logfile}
 echo "Performed: `date '+%Y-%m-%d, %H:%M:%S'`." >> ${logfile}
+echo "Storage format: ${format}." >> ${logfile}
 echo "--------------------------------------------------------" >> ${logfile}
 
@@ -96,7 +107,8 @@
 	report $? log
 	# dump references
-	reffile="${dirname}/${references_backup}"
+	reffile="${dirname}/${references_backup}.${extension}"
 	echo -n "  Backing up references ... " | tee -a ${logfile}
-	refdbc -C getref -d ${db} -t ris -o ${reffile} ":ID:>0" &> /dev/null
+	refdbc -C getref -d ${db} -t ${format} -o ${reffile} ":ID:>0" \
+			&> /dev/null
 	report $? log
 	# dump notes
@@ -139,5 +151,6 @@
 for file in `ls -1  | sed -e 's/ \+/ /g' | cut -d ' ' -f 8 | grep -v '^$'` ; do
 	[ `echo ${file} | grep "^refdb_backup" | wc -l` -ne 1 ] \
-			&& rm -fr ${file} &> /dev/null
+		&& [ `echo ${file} | grep "^${logfile}" | wc -l` -ne 1 ] \
+		&& rm -fr ${file} &> /dev/null
 done
 echo "OK."

Index: refdb-restore
===================================================================
RCS file: /cvsroot/refdb/refdb/scripts/refdb-restore,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -U2 -r1.1 -r1.2
--- refdb-restore	30 Jan 2005 01:09:09 -0000	1.1
+++ refdb-restore	30 Jan 2005 10:31:25 -0000	1.2
@@ -14,5 +14,5 @@
 
 # VARIABLES
-references_backup="references.ris"
+references_backup="references"
 notes_backup="xnotes.xml"
 styles_directory="styles"
@@ -23,4 +23,6 @@
 
 # Report success of operation
+#   params: 1 - exit status
+#   return: nil
 report () {
 	if [ $1 -eq 0 ] ; then
@@ -31,4 +33,7 @@
 }
 # Report failure and abort
+#   params: 1 - exit message
+#           2 - success indicator ( 'succeeded'|* )
+#   retuns: nil
 endScript () {
 	echo ; echo "$1"
@@ -46,4 +51,6 @@
 }
 # Show usage
+#   params: nil
+#   return: nil
 displayUsage () {
 	echo "`basename $0`: Restores RefDb data from backup."
@@ -54,4 +61,33 @@
 	echo "Must be archive created by 'refdb-backup' utility."
 }
+# Determine name of reference database backup file
+#   params: 1 - archive name
+#           2 - database name
+#           3 - backup file basename
+#   return: filename ('db_DBNAME/BACKUPFILE.EXTENSION')
+get_filename () {
+	archive=$1
+	db=$2
+	base=$3
+	filelist=`unzip -l $1 | sed -e 's/ \+/ /g' | cut -d ' ' -f 5 | grep -v '^$' | sed -e '1,2d' | grep -v "/$" | grep "^db_"`
+	[ `echo "${filelist}" | grep "^db_${db}/${references_backup}.xml"` ] \
+		&& extension="xml"
+	[ `echo "${filelist}" | grep "^db_${db}/${references_backup}.ris"` ] \
+		&& extension="ris"
+	echo "db_${db}/${references_backup}.${extension}"
+}
+# Determines format of backup reference file
+#   params: 1 - backup filepath
+#   return: format ('ris'|'risx')
+get_format () {
+	filepath=$1
+	filename=${filepath##*/}  # strip path
+	extension=${filename##*.}  # strip basename
+	case ${extension} in
+		ris ) echo "ris";;
+		xml ) echo "risx";;
+		*   ) echo "ERROR";;
+	esac
+}
 
 
@@ -90,5 +126,6 @@
 		echo "Restoring database: ${db}" | tee -a ${logfile}
 		# restore references
-		reffile="db_${db}/${references_backup}"
+		#reffile="db_${db}/${references_backup}"
+		reffile=`get_filename $1 ${db} ${references_backup}`
 		echo "  Restore references" | tee -a ${logfile}
 		# - extract file
@@ -103,5 +140,6 @@
 		# - add references
 		echo -n "    Adding references ... " | tee -a ${logfile}
-		refdbc -C addref -d ${db} -t ris ${reffile} >> ${logfile}
+		format=`get_format ${reffile}`
+		refdbc -C addref -d ${db} -t ${format} ${reffile} >> ${logfile}
 		report $?
 		# - delete file

Update of /cvsroot/refdb/refdb/scripts
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv25119

Added Files:
      Tag: Release_0_9_5_stable
	refdb-backup refdb-restore 
Log Message:
moved over to stable branch

--- NEW FILE ---
#!/bin/sh

# File: refdb-backup

# Author: David Nebauer

# History: 2004-11-28 Created

# Purpose: Backups references, notes and styles


# VARIABLES
references_backup="references"
notes_backup="xnotes.xml"
styles_directory="styles"
logfile="log_backup"
archive="refdb_backup_`date '+%Y%m%d_%H%M'`.tar.gz"


# PROCEDURES

# Report success of operation
report () {
	if [ $1 -eq 0 ] ; then
		if [ "$2" = "log" ] ; then
			echo "OK." | tee -a ${logfile}
		else
			echo "OK."
		fi
	else
		if [ "$2" = "log" ] ; then
			echo "Failed." | tee -a ${logfile}
		else
			echo "Failed."
		fi
	fi
}
# Report failure and abort
endScript () {
	echo ; echo "$1"
	echo ; echo "refdb backup $2."
	echo "`basename $0` is finished."
	if [ "$2" = "succeeded" ] ; then
		# Single tone indicates success
		echo -ne "\a"
		exit 0
	else
		# Double tone indicates failure
		echo -ne "\a" ; sleep 1s ; echo -ne "\a"
		exit 1
	fi
}
# Show usage
displayUsage () {
	echo "`basename $0`: Backs up RefDB data."
	echo
	echo "Usage: `basename $0`"
	echo
	echo "Backs up references, notes and styles from RefDB."
	echo "Must be run in an empty directory."
}


# MAIN

# Check parameters
[ $# -gt 1 ] \
		&& echo "Invalid parameters.  Try '`basename $0` -h'." \
		&& exit 1
[ $# -eq 1 ] && case $1 in
	-h | --help ) displayUsage ; exit 0;;
	* ) echo "Invalid parameter. Try '`basename $0` -h'." ; exit 1;;
esac

# Must be run in empty directory
if [ `ls | grep -v total | wc -l` -ne 0 ] ; then
	echo ; echo "This directory is not empty."
	echo "'`basename $0`' must be run from an empty directory."
	endScript "Aborted." "failed"
fi

# Informational message
echo "`basename $0` is running..." ; echo

# Select storage format
old_PS3=${PS3}
PS3="Select the storage format for references: "
select format in "ris" "risx" ; do break ; done
case ${format} in
	ris  ) extension="ris";;
	risx ) extension="xml";;
	*    ) endScript "No format selected." "failed";;
esac
echo ; echo "References storage format: ${format}." ; echo

# Record date/time of backup
echo "RefDB backup performed by '`basename $0`'." > ${logfile}
echo "Performed: `date '+%Y-%m-%d, %H:%M:%S'`." >> ${logfile}
echo "Storage format: ${format}." >> ${logfile}
echo "--------------------------------------------------------" >> ${logfile}

# Cycle through databases in turn and backup references and notes
for db in `refdba -C listdb | cut --delimiter=' ' --fields=1` ; do
	echo "Processing database: ${db}" | tee -a ${logfile}
	dirname="db_${db}"
	echo -n "  Creating subdirectory '${dirname}' ... " | tee -a ${logfile}
	mkdir ${dirname} &> /dev/null
	report $? log
	# dump references
	reffile="${dirname}/${references_backup}.${extension}"
	echo -n "  Backing up references ... " | tee -a ${logfile}
	refdbc -C getref -d ${db} -t ${format} -o ${reffile} ":ID:>0" \
			&> /dev/null
	report $? log
	# dump notes
	notefile="${dirname}/${notes_backup}"
	echo -n "  Backing up notes ... " | tee -a ${logfile}
	refdbc -C getnote -d ${db} -t xnote -o ${notefile} ":NID:>0" \
			&> /dev/null
	report $? log
done

# Cycle through styles in turn and back them up
echo "Processing styles" | tee -a ${logfile}
echo -n "  Creating styles directory '${styles_directory}' ... " \
		| tee -a ${logfile}
mkdir ${styles_directory} &> /dev/null
report $? log
for style in `refdba -C liststyle` ; do
	echo -n "  Backing up style: ${style} ... " | tee -a ${logfile}
	# remove terminal period from file name if present
	if [ `echo ${style} | grep "\.$" | wc -l` -eq 1 ] ; then
		stylefile=${style%*.}
	else
		stylefile=${style}
	fi
	stylefile="${styles_directory}/${stylefile}.xml"
	refdba -C getstyle -o ${stylefile} ${style} &> /dev/null
	report $? log
done

# Now done
echo "--------------------------------------------------------" >> ${logfile}
echo "Written log file: ${logfile}."

# Zip files
echo "Compressing to archive"
echo -n "  Writing archive ... "
#find . -name '*' | zip ${archive} -@ &> /dev/null
tar -czf ${archive} *
report $?
echo -n "  Deleting backup files ... "
for file in `ls -1  | sed -e 's/ \+/ /g' | cut -d ' ' -f 8 | grep -v '^$'` ; do
	[ `echo ${file} | grep "^refdb_backup" | wc -l` -ne 1 ] \
		&& [ `echo ${file} | grep "^${logfile}" | wc -l` -ne 1 ] \
		&& rm -fr ${file} &> /dev/null
done
echo "OK."

# Finished
echo ; echo "Backup archive: '${archive}'."
endScript "Backup finished." "succeeded"

--- NEW FILE ---
#!/bin/sh

# File: refdb-backup

# Author: David Nebauer

# History: 2004-11-28 Created
#          2005-01-27 Delete directories when done

# Purpose: Restores references, notes and styles

# Parameter: 1 - backup archive


# VARIABLES
references_backup="references"
notes_backup="xnotes.xml"
styles_directory="styles"
logfile="log_restore"


# PROCEDURES

# Report success of operation
#   params: 1 - exit status
#   return: nil
report () {
	if [ $1 -eq 0 ] ; then
		echo "OK." | tee -a ${logfile}
	else
		echo "Failed." | tee -a ${logfile}
	fi
}
# Report failure and abort
#   params: 1 - exit message
#           2 - success indicator ( 'succeeded'|* )
#   retuns: nil
endScript () {
	echo ; echo "$1"
	echo ; echo "refdb restore $2."
	echo "`basename $0` is finished."
	if [ "$2" = "succeeded" ] ; then
		# Single tone indicates success
		echo -ne "\a"
		exit 0
	else
		# Double tone indicates failure
		echo -ne "\a" ; sleep 1s ; echo -ne "\a"
		exit 1
	fi
}
# Show usage
#   params: nil
#   return: nil
displayUsage () {
	echo "`basename $0`: Restores RefDb data from backup."
	echo
	echo "Usage: `basename $0` <backup_archive>"
	echo
	echo "Restores references, notes and styles from backup archive."
	echo "Must be archive created by 'refdb-backup' utility."
}
# Determine name of reference database backup file
#   params: 1 - archive name
#           2 - database name
#           3 - backup file basename
#   return: filename ('db_DBNAME/BACKUPFILE.EXTENSION')
get_filename () {
	archive=$1
	db=$2
	base=$3
	filelist=`tar -tzf $1 | grep -v "/$" | grep "^db_"`
	[ `echo "${filelist}" | grep "^db_${db}/${references_backup}.xml"` ] \
		&& extension="xml"
	[ `echo "${filelist}" | grep "^db_${db}/${references_backup}.ris"` ] \
		&& extension="ris"
	echo "db_${db}/${references_backup}.${extension}"
}
# Determines format of backup reference file
#   params: 1 - backup filepath
#   return: format ('ris'|'risx')
get_format () {
	filepath=$1
	filename=${filepath##*/}  # strip path
	extension=${filename##*.}  # strip basename
	case ${extension} in
		ris ) echo "ris";;
		xml ) echo "risx";;
		*   ) echo "ERROR";;
	esac
}


# MAIN

# Check parameters
[ $# -ne 1 ] \
		&& echo "Invalid parameters.  Try '`basename $0` -h'." \
		&& exit 1
[ $# -eq 1 ] && case $1 in
	-h | --help ) displayUsage ; exit 0;;
esac

# Run tests on archive
# - must exist and be readable
[ -r $1 ] || endScript "Cannot read backup archive '$1'." "failed"
# - must be valid archive (this test is a bit crude - just list
#   archive contents and check exit status)
tar -tzf $1 &> /dev/null
[ $? -ne 0 ] && endScript "'$1' is not a valid archive." "failed"

# Informational message
echo "`basename $0` is running..." ; echo

# Record date/time of backup
echo "RefDB restore performed by '`basename $0`'." > ${logfile}
echo "Performed: `date '+%Y-%m-%d, %H:%M:%S'`." >> ${logfile}
echo "Backup archive: '$1'." >> ${logfile}
echo "--------------------------------------------------------" >> ${logfile}

# Cycle through databases in turn and restore references and notes
for dbdir in `tar -tzf $1 | grep "/$"` ; do
	# get db name
	if [ ${dbdir} != "styles/" ] ; then
		db=${dbdir##db_}  # remove prefix
		db=${db%%/}  # remove trailing slash
		echo "Restoring database: ${db}" | tee -a ${logfile}
		# restore references
		reffile=`get_filename $1 ${db} ${references_backup}`
		echo "  Restore references" | tee -a ${logfile}
		# - extract file
		echo -n "    Extracting temporary file ... " | tee -a ${logfile}
		echo "" >> ${logfile}
		tar -xzf $1 ${reffile} >> ${logfile}
		report $?
		# - create database
		echo -n "    Create database ... " | tee -a ${logfile}
		refdba -C createdb ${db} >> ${logfile}
		report $?
		# - add references
		echo -n "    Adding references ... " | tee -a ${logfile}
		format=`get_format ${reffile}`
		refdbc -C addref -d ${db} -t ${format} ${reffile} >> ${logfile}
		report $?
		# - delete file
		echo -n "    Deleting temporary file ... " | tee -a ${logfile}
		rm -f ${reffile}
		report $?
		# restore notes
		notefile="db_${db}/${notes_backup}"
		echo "  Restore notes" | tee -a ${logfile}
		# - extract file
		echo -n "    Extracting temporary file ... " | tee -a ${logfile}
		echo "" >> ${logfile}
		tar -xzf $1 ${notefile} >> ${logfile}
		report $?
		# - add notes
		echo -n "    Adding notes ... " | tee -a ${logfile}
		refdbc -C addnote -d ${db} ${notefile} >> ${logfile}
		report $?
		# - delete file
		echo -n "    Deleting temporary file ... " | tee -a ${logfile}
		rm -f ${notefile}
		report $?
		# delete database directory
		echo -n "  Deleting temporary db directory ... " | tee -a ${logfile}
		rmdir db_${db}
		report $?
	fi
done

# Restore styles
echo "Restoring styles" | tee -a ${logfile}
for stylefile in `tar -tzf $1 | grep "^styles/[[:print:]]\+"` ; do
	# extract style file
	echo -n "  Extracting style: " | tee -a ${logfile}
	echo "" >> ${logfile}
	tar -xzf $1 ${stylefile} >> ${logfile}
	if [ $? -eq 0 ] ; then
		# extract style name
		stylename=`grep "^[[:print:]]*<STYLENAME>" ${stylefile}`
		stylename=${stylename#[[:print:]]*<STYLENAME>}
		stylename=${stylename%<\/STYLENAME>}
		echo ${stylename}
		# add style
		echo -n "    Adding style ... " | tee -a ${logfile}
		refdba -C addstyle ${stylefile} >> ${logfile}
		report $?
		echo -n "    Deleting temporary file ... " | tee -a ${logfile}
		rm -f ${stylefile}
		report $?
	else
		report 1
	fi
done
# delete styles directory
echo -n "  Deleting styles directory ... " | tee -a ${logfile}
rmdir styles
report $?

# Now done
echo "--------------------------------------------------------" >> ${logfile}
echo "Written log file: ${logfile}."

# Finished
endScript "Restore finished." "succeeded"