# recreate
# usage: recreate <database> <user> <password>
# example: recreate SuppDB 4311 4311 
# note: expects SuppDB.dd to create the data dictionary
#       expects SuppDB.data to insert new data

# remove the old database
mysqladmin -u $2 -p$3 -h gold drop $1

# create a new database
mysqladmin -u $2 -p$3 -h gold create $1

# load the data dictionary (metadata)
mysql -u $2 -p$3 -h gold $1 <$1.dd

# load the actual data
mysql -u $2 -p$3 -h gold $1 <$1.data