#!/bin/bash
PATH="/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin"
db_host="localhost"
db_user="backup"
db_pass="XXXXXXXXXXXXXX"
backup_dir="/var/backups/env_sync"
panel_tables=( contacts:panelist_id contacts_addresses:address_id contacts_emails:email_id contacts_numbers:number_id contacts_others:panelist_id contacts_updates:timestamp excluded_single_emails:email panel_audit:panelist_id access_contacts_bridge:PANEL )

echo -n "Prepping dump location $(date)..."
mkdir -p $backup_dir && chown mysql $backup_dir && find $backup_dir -type f -name "*.out" | xargs rm -fv
echo "Done"

for obj in ${panel_tables[@]}
  do
    table=$(echo $obj | awk -F: '{print $1}')
    key=$(echo $obj | awk -F: '{print $2}')
    echo -n "Dumping random data for table: $table $(date)... "
    sqlq="select * from $table where $key in (select $key from $table order by rand()) limit 10000 into outfile '$backup_dir/$table.out'"
    mysql -h $db_host -u $db_user -p$db_pass -Bse "$sqlq" panel
    echo "Done $(date)"
done