diff options
| author | Cecil Hugh Watson <knoppmyth@gmail.com> | 2009-01-19 08:00:36 (GMT) |
|---|---|---|
| committer | Cecil Hugh Watson <knoppmyth@gmail.com> | 2009-01-19 08:00:36 (GMT) |
| commit | 6f90626a0bf289be8f0497fd6b135c7ef831e0fd (patch) | |
| tree | a6bb8ed23d252765f1a7888ed079ec156cd68e81 /abs/core-testing/zoneminder/zmeventdump | |
| parent | 100915fd681da7bd7d56311c6f866003d88e6141 (diff) | |
| download | linhes_pkgbuild-6f90626a0bf289be8f0497fd6b135c7ef831e0fd.zip linhes_pkgbuild-6f90626a0bf289be8f0497fd6b135c7ef831e0fd.tar.gz linhes_pkgbuild-6f90626a0bf289be8f0497fd6b135c7ef831e0fd.tar.bz2 | |
MythZoneMinder, ZoneMinder and deps.
Diffstat (limited to 'abs/core-testing/zoneminder/zmeventdump')
| -rwxr-xr-x | abs/core-testing/zoneminder/zmeventdump | 48 |
1 files changed, 48 insertions, 0 deletions
diff --git a/abs/core-testing/zoneminder/zmeventdump b/abs/core-testing/zoneminder/zmeventdump new file mode 100755 index 0000000..17087b9 --- /dev/null +++ b/abs/core-testing/zoneminder/zmeventdump @@ -0,0 +1,48 @@ +#!/bin/bash +#=============================================================================== +# +# FILE: eventdump.sh +# +# USAGE: ./eventdump.sh +# +# DESCRIPTION: Uses mysqldump to create a .sql file for individual zm +# events to make Event table recovery possible by doing a +# 'find' search in ZoneMinder the events directory +# +# OPTIONS: --- +# REQUIREMENTS: --- mysqldump +# BUGS: --- +# NOTES: --- +# AUTHOR: Ross Melin <rdmelin@gmail.com> +# COMPANY: +# VERSION: 1.0 +# CREATED: 03/06/2008 11:51:19 AM PST +# REVISION: --- +#=============================================================================== + +# Edit these to suit your configuration +ZM_CONFIG=/etc/zm.conf +MYSQLDUMP=/usr/bin/mysqldump +EVENTSDIR=/home/httpd/html/zm/events + +# The rest should not need editing + +# Get the mysql user and password +source $ZM_CONFIG +MYDUMPOPTS="--user=$ZM_DB_USER --password=$ZM_DB_PASS --skip-opt --compact --quick --no-create-info" + + +for tag in $(find $EVENTSDIR -amin -65 -name ".[0-9]*") + do + EVENT_PATH=$(echo $tag |cut -f 1 -d .) + EVENT_ID=$(echo $tag |cut -f 2 -d .) + # Dump the sql statements needed to reload the Events, Frames and Stats tables + + echo "-- ZM_DB_VERSION=$ZM_VERSION +" > $EVENT_PATH.sql + + $MYSQLDUMP $MYDUMPOPTS --where="Id=$EVENT_ID" zm Events >> $EVENT_PATH.sql + $MYSQLDUMP $MYDUMPOPTS --where="Eventid=$EVENT_ID" zm Frames >> $EVENT_PATH.sql + $MYSQLDUMP $MYDUMPOPTS --where="Eventid=$EVENT_ID" zm Stats >> $EVENT_PATH.sql + +done |