delete_all_kalibro_entries.sh 412 Bytes
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 
#!/bin/bash

DATABASE="kalibro_tests"
USER="kalibro"
PASSWORD="kalibro"
MYSQL_PARAMS="$DATABASE -u $USER -p$PASSWORD"
TABLES=($(mysql $MYSQL_PARAMS -e "show tables"))
LENGTH=${#TABLES}

i=1
while [ $i -le $LENGTH ]
  do  if [ ${#TABLES[$i]} -ne 0 ]
        then  mysql $MYSQL_PARAMS -e "SET FOREIGN_KEY_CHECKS = 0; delete from $DATABASE.${TABLES[$i]}; SET FOREIGN_KEY_CHECKS = 1;"
      fi
      i=$(($i+1))
done