Import .sql files as tables to the database with the directoryname they are in.

foreign_key_checks_OFF.sql

SET foreign_key_checks = 0;

foreign_key_checks_ON.sql

SET foreign_key_checks = 1;

import_DBs_by_DIR.sh

#!/bin/sh
DB_SERVER="localhost"
DB_USER="xxxxxx"
DB_PASS="yyyyyy"

ROOT=`pwd`

for DIR in `find . -mindepth 1 -type d`; do
  echo "Test"
  echo "enterning $DIR ..."
  DB=$(echo $DIR | cut -c 3-)
  cd $DIR

  for FILE in *.sql
  do
    echo ""
    echo "$DIR/$FILE"
    mysql -u $DB_USER -p$DB_PASS -h $DB_SERVER $DB < $ROOT/foreign_key_checks_OFF.sql
    pv "$FILE" | mysql -u $DB_USER -p$DB_PASS -h $DB_SERVER $DB
    mysql -u $DB_USER -p$DB_PASS -h $DB_SERVER $DB < $ROOT/foreign_key_checks_ON.sql
  done

  cd ..
done