db='tracker'

# LOAD TRACKER DATABASE
echo " " > load.sql
for table in  \
	invoicelineitem expense work cashwithdrawals cashdeposits buglog bug \
	persbudgproj budgetproject accountsrecv project budget companyperson \
	company userauth person users domain
{
	echo deleting $table...
	echo "delete from $table;" >> load.sql
}

curd="$HOME/public_html/TRACKER/bulkload"

for table in  \
	domain users person userauth company companyperson budget project accountsrecv \
	budgetproject persbudgproj bug buglog cashdeposits cashwithdrawals work expense  \
	invoicelineitem
{
	echo loading $table...
	echo "load data local infile '$curd/$table.out' into table $table fields terminated by '|';" >> load.sql
}

mysql -u jhook_2 -h db103b.pair.com -p jhook_tracker < load.sql