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

Error: Macro BackLinks(None) failed

'Environment' object has no attribute 'get_db_cnx'