#!/bin/bash

# Expect to export from CentOS
RELEASE=$(cat /etc/redhat-release)
EXPECTED_OS=CentOS
echo $RELEASE
if [[ "$RELEASE" != *"$EXPECTED_OS"* ]]; then
  echo "When exporting we expect $EXPECTED_OS"
  exit
fi

EXPORT_SUFFIX=$(date +%Y_%B)
echo "$EXPORT_SUFFIX"
PASSWORD=
USER=root
DATABASE=sog
DB_DATA=db-sog-logs-$EXPORT_SUFFIX.sql
# Ignore big log tabke
EXCLUDED_TABLES=(
glam_access_point_log 
)

mysqldump --user=${USER} -p --no-create-info --skip-triggers sog glam_access_point_log --where="key_log_time >= unix_timestamp('2023-01-01 00:00:00')" > $DB_DATA
# Move to place we can download

echo "Move to HTTP client directory for download"
mv ${DB_DATA} /usr/share/tomcat6/webapps/ROOT/

echo "Done"