= OpenSpecimen HowTo Backup Database for Development Server

Tags: [[OpenSpecimen]] [[HowTo]] [[Database]]

== Procedure

1. Run the following command to back up the database, but ignore the audit files, which are very large:

{{{
mysqldump -u lampuser -p --ignore-table=catissueplus30.catissue_data_audit_event_log --ignore-table=catissueplus30.catissue_audit_event_query_log --ignore-table=catissueplus30.catissue_audit_event_details --ignore-table=catissueplus30.catissue_audit_event_log --ignore-table=catissueplus30.catissue_audit_event catissueplus30 > caTissue.sql
}}}

2. When you restore the DB over the existing DB on the other machine, you have to make sure that the `{Open Specimen Directory}/app/webapps/openspecimen/WEB-INF/classes/application.properties` field `datasource.type` is set to `upgrade`.  (I think! It errors if you don't do this.  It errors if you do, but still seems to work.)

[[BackLinks]]