#! /bin/bash

# Note: This script disables foreign key checks and ignores all errors!

DUMPDIR='/tmp/mysql_dumps/'

USERNAME='root'
PASSWORD='MyP@55'
DATABASE='databaseName'

cd ${DUMPDIR}

# import table structures
for i in *.sql
do
  # get table name from filename
  TABLE=$(echo $i | cut -f 1 -d '.')
  echo "creating table ${DATABASE}.${TABLE} from ${DUMPDIR}${i} ..."
  mysql -u ${USERNAME} -p${PASSWORD} --init-command="SET SESSION FOREIGN_KEY_CHECKS=0;" ${DATABASE} < ${i}
done

# import data
for i in *.txt
do
  # get table name from filename
  TABLE=$(echo $i | cut -f 1 -d '.')
  echo "importing data to ${DATABASE}.${TABLE} from ${DUMPDIR}${i}..."
  mysql -u${USERNAME} -p${PASSWORD} -e "SET SESSION FOREIGN_KEY_CHECKS=0; LOAD DATA INFILE '${DUMPDIR}${i}'  IGNORE INTO TABLE ${TABLE};" ${DATABASE} < ${i}
done