Import SQL from nightly dump

import_sql.sh

#!/usr/bin/env bash

# Create the MySQL tables
for file in *.sql
  do
    echo $file
    cat $file | mysql -u USER -pPASS DBNAME
    cat $file | mysql -u USER -pPASS DBNAME
  done

# Import the data
for data in *.txt
 do
   mysqlimport -u USER -pPASS --local DBNAME $data
   mysqlimport -u USER -pPASS --local DBNAME $data
 done