wiki:OpenSpecimen HowTo Backup Database for Development Server

Version 5 (modified by Richard Bramley, 9 years ago) ( diff )

--

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 --events --routines --triggers --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
  1. 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.)

Error: Macro BackLinks(None) failed
'Environment' object has no attribute 'get_db_cnx'

Note: See TracWiki for help on using the wiki.