delete from invoicelineitem;
delete from expense;
delete from work;
delete from cashwithdrawals;
delete from cashdeposits;
delete from buglog;
delete from bug;
delete from persbudgproj;
delete from budgetproject;
delete from accountsrecv;
delete from project;
delete from budget;
delete from companyperson;
delete from company;
delete from userauth;
delete from person;
delete from users;
delete from domain;
load data local infile '/usr/home/jhook/public_html/TRACKER/bulkload/domain.out' into table domain fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/TRACKER/bulkload/users.out' into table users fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/TRACKER/bulkload/person.out' into table person fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/TRACKER/bulkload/userauth.out' into table userauth fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/TRACKER/bulkload/company.out' into table company fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/TRACKER/bulkload/companyperson.out' into table companyperson fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/TRACKER/bulkload/budget.out' into table budget fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/TRACKER/bulkload/project.out' into table project fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/TRACKER/bulkload/accountsrecv.out' into table accountsrecv fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/TRACKER/bulkload/budgetproject.out' into table budgetproject fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/TRACKER/bulkload/persbudgproj.out' into table persbudgproj fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/TRACKER/bulkload/bug.out' into table bug fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/TRACKER/bulkload/buglog.out' into table buglog fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/TRACKER/bulkload/cashdeposits.out' into table cashdeposits fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/TRACKER/bulkload/cashwithdrawals.out' into table cashwithdrawals fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/TRACKER/bulkload/work.out' into table work fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/TRACKER/bulkload/expense.out' into table expense fields terminated by '|';
load data local infile '/usr/home/jhook/public_html/TRACKER/bulkload/invoicelineitem.out' into table invoicelineitem fields terminated by '|';