#!/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