#!/bin/sh

# backup for patient & request data from hilis4 tables

DBUSER=raj
DBPASS=adm1n
SRC=hilis4
outfile=dummy_data

# -t = Do not write CREATE TABLE statements that re-create each dumped table;
# -c = Use complete INSERT statements that include column names
mysqldump -u $DBUSER -p$DBPASS $SRC -t -c  \
patient_case \
patient_edits \
patient_trial \
patients \
request_audit \
request_consent \
request_diagnosis_history \
request_error_code \
request_external_ref \
request_history \
request_initial_screen \
request_lab_section_notes \
request_lab_test_history \
request_lab_test_results \
request_option \
request_phone_log \
request_report \
request_report_history \
request_result_summaries \
request_specimen \
request_trial \
requests \
screen_lab_test \
screen_lab_test_detail \
specimen_lab_test \
users \
> $outfile.sql
