#! /bin/sh
##
## Usage:
##     run-mysql $1 $2 $3 $4 $5 $6 $7 $8 $9
##
## $1 = host machine for MySQL server
## $2 = MySQL database name
## $3 = MySQL userid
## $4 = password for userid
## $5 = path to directory containing input files
## $6 = version of source database 
## $7 = release date of the source database
## $8 = ORFs to load - ALL | ORIGINAL | PRIMARY | TIGR 
## $9 = optional; port to communicate with MySQL server

port=3306; export port
if [ "$9" != "" ]
  then port=$8
fi

./mysql-cmr-loader -h $1 -b $2 -u $3 -p $4 -d $5 -v $6 -r $7 -o $8 -t $port