#!/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