patch for database backup scripts

Forum for questions and support relating to the 1.24.x releases only.
Locked
User avatar
rdmelin
Posts: 863
Joined: Wed Oct 29, 2003 2:23 pm
Location: Ellensburg, WA USA

patch for database backup scripts

Post by rdmelin »

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
User avatar
zoneminder
Site Admin
Posts: 5215
Joined: Wed Jul 09, 2003 2:07 pm
Location: Bristol, UK
Contact:

Post by zoneminder »

Thanks Ross. Changes applied and will be up in new RC later today.
Phil
User avatar
zoneminder
Site Admin
Posts: 5215
Joined: Wed Jul 09, 2003 2:07 pm
Location: Bristol, UK
Contact:

Post by zoneminder »

This has now been uploaded.
Phil
Locked