Yeah, that would probably do it. And since neither the dump nor the select produced anything they would match...  Sigh... Maybe I should add an extra check that the counts are not all 0... 
I'm thinking something like this (untested):
Code: *** /usr/local/bin/backupcommon Mon May 14 22:52:14 2007
--- backupcommon Sat May 26 21:00:08 2007
***************
*** 157,162 ****
--- 157,176 ----
return $FILE_STATUS
}
+ has_records () {
+ filename="$1"
+ description="$2"
+ if [ $(wc -l < "$filename") -eq 0 ] ; then
+ echo "Warning, could not get record counts from $description!"
+ return 1
+ fi
+ if [ $(awk '{cnt+=$2} END {print cnt}' < "$filename") -eq 0 ] ; then
+ echo "Warning, total record count from $description is zero!"
+ return 1
+ fi
+ return 0
+ }
+
check_tables () {
LIVE_TABLES=/tmp/live_tables_$$
SAVED_TABLES=/tmp/saved_tables_$$
***************
*** 180,191 ****
--- 194,207 ----
records[tbl] += n; } \
END { for (tbl in records) print tbl, records[tbl]; }' |
/bin/sed 's/mythlog [0-9]*/mythlog 0/' | /usr/bin/sort >$SAVED_TABLES
+ has_records "$SAVED_TABLES" "DB dump" || return 1
echo "Generating a list of tables and record counts in the live DB..."
for tbl in $((cd $DATABASE_DIR ; /bin/ls *.MYD) | /bin/sed '/\.MYD$/s///'$
/usr/bin/mysql mythconverg -sBe "select '$tbl', count(*) from $tbl"
done | /usr/bin/tr -s '\t' ' ' |
/bin/sed 's/mythlog [0-9]*/mythlog 0/' | /usr/bin/sort >$LIVE_TABLES
+ has_records "$LIVE_TABLES" "live DB" || return 1
echo "Comparing live versus saved tables..."
/usr/bin/diff $LIVE_TABLES $SAVED_TABLES
|
