OpenSpecimen is supported on MySQL DB. If you want to take a copy or back of the database, follow the steps mentioned in this document.
Commands to export/import MySQL DB:
Run below commands from command prompt:
To export MySQL database:
mysqldump -P 3306 -h [ip_address] -u [uname] -p[pass] --routines db_name > db_backup.sql
Note: Mentioning port is optional if default 3306 is used and mentioning host is optional if host is localhost.
The exported file gets created in the folder form where you ran the command.
To import MySQL database:
mysql -u [uname] -p[pass] -h [ip_address] db_name < db_backup.sql
Note: Mention the full path of the backup file if it's not in the same folder as the folder from where command is run.