OpenSpecimen is supported on MySQL DB. If Follow the steps mentioned in this document 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 a command prompt:
To export a MySQL database:
| Code Block |
|---|
mysqldump -P 3306 -h [ip_address] -u [uname] -p[pass] --routines dbroutines db_name > db_backup.sql |
Note:
MentioningMentioning port is optional if default 3306 is used, and mentioning host is optional if the host is localhost.
The exported file gets created in the folder form where you ran the command.
To import the MySQL database:
| Code Block |
|---|
mysql -u [uname] -p[pass] -h [ip_address] db_name < db_backup.sql |
Note: Mention Mention the full path of the backup file if it's not in the same folder as the folder from where the command is run.