#!/bin/bash

skipdisablekeys=0

mysql -e 'DROP DATABASE IF EXISTS testdb;CREATE DATABASE testdb;'
mysql testdb -e 'CREATE TABLE testtable ( id int, a int,PRIMARY KEY (id)) ENGINE=InnoDB;'
mysql testdb -e 'INSERT INTO testtable VALUES (1,2),(2,3),(3,4);'
if [[ "$skipdisablekeys" == "0" ]]; then
  echo "Testing with disabled keys"
  mysqldump testdb testtable > dump.sql
else
  echo "Testing without disabled keys"
  mysqldump --skip-disable-keys testdb testtable > dump.sql
fi

systemctl restart mariadb
mysql -V

while :
do
  mysql -e 'DROP DATABASE IF EXISTS testdb;CREATE DATABASE testdb;'
  mysql testdb < dump.sql
  echo `date` - `mysql testdb -e 'SHOW TABLE STATUS LIKE "testtable"\G' | grep Rows`
  sleep 10
done