patch for database backup scripts
Posted: Mon Sep 29, 2008 10:33 pm
Phil here are some small fixes. I have tested with the latest and the scripts are good to go with these fixes.
Code: Select all
diff -Naur ZoneMinder-1.24.0.orig/scripts/zmdbbackup.in ZoneMinder-1.24.0/scripts/zmdbbackup.in
--- ZoneMinder-1.24.0.orig/scripts/zmdbbackup.in 2008-02-25 01:49:52.000000000 -0800
+++ ZoneMinder-1.24.0/scripts/zmdbbackup.in 2008-09-26 12:18:46.000000000 -0700
@@ -29,7 +29,7 @@
OUTFILE="$BACKUP_PATH/$BACKUP_FILE"
echo "--
---- Created by zm_db_backup for ZoneMinder Version $ZM_VERSION
+-- Created by zm_db_backup for ZoneMinder Version $ZM_VERSION
--" > $OUTFILE
$MYSQLDUMP $DUMPOPTS zm $TABLES >> $OUTFILE
diff -Naur ZoneMinder-1.24.0.orig/scripts/zmeventdump.in ZoneMinder-1.24.0/scripts/zmeventdump.in
--- ZoneMinder-1.24.0.orig/scripts/zmeventdump.in 2008-03-02 09:42:34.000000000 -0800
+++ ZoneMinder-1.24.0/scripts/zmeventdump.in 2008-09-26 12:18:20.000000000 -0700
@@ -40,7 +40,7 @@
# Dump the sql statements needed to reload the Events, Frames and Stats tables
-echo "--- ZM_DB_VERSION=$ZM_VERSION
+echo "-- ZM_DB_VERSION=$ZM_VERSION
" > $EVENT_PATH/.sql
$MYSQLDUMP $MYDUMPOPTS --where="Id=$EVENT_ID" zm Events >> $EVENT_PATH/.sql
diff -Naur ZoneMinder-1.24.0.orig/scripts/zmlogrotate.conf.in ZoneMinder-1.24.0/scripts/zmlogrotate.conf.in
--- ZoneMinder-1.24.0.orig/scripts/zmlogrotate.conf.in 2008-02-25 01:49:52.000000000 -0800
+++ ZoneMinder-1.24.0/scripts/zmlogrotate.conf.in 2008-09-26 12:19:21.000000000 -0700
@@ -7,7 +7,7 @@
missingok
}
-Now the weekly db backup
+# Now the weekly db backup
/var/lib/zm/zm_backup.sql {
weekly