...

1. Log in to the server from which you want to take backup.

2. Open context.xml file from $TOMCAT_HOME/conf/context.xml to get a Username and Password of that database.

   Code Block
   language xml title Username and Password from the context.xml file
   <Resource name="jdbc/openspecimen" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="root" password="<password>" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/<database name>" validationInterval="3600" testOnBorrow="true" validationQuery="Select 1 from dual" />

   
   

3. Access the database using mysql -u<username> -p command

4. Take the backup of the database using db_export_script.sh  script. (Fill the appropriate values in the script for DB name, user, root password, hostname etc..)

5. Take the backup of the data folder of OpenSpecimen.

...

Errors may occur after taking the database backup from one server to another server.

Error 1: "couldn't create the directory for storing de file data."

Reason: While taking database backup from the server1 all OpenSpecimen related configuration setting comes with the database dump. so the data directory path of server 1 also comes with the database dump file. so when we take this dump to another server say server 2 and import that dump file to MySQL. (Remember data directory path is same as Server 1. which is not valid).& when we Start the server we get above error because server 2 don't have permission to create the directory which is an actually wrong path.

Solution: Update the path of data directory in the database and restart the server.

Connect to the MySQL. get into the database.

Step 1: Get the Identifier value for the property data_dir.

select * from os_cfg_props where name = 'data_dir';

...

update os_cfg_settings set activity_Status = 'Active' where identifier = <Identifieer value of Step 2>;

Error 2:  "Invalid label print output directory."

Reason: The reason for this error is also the same as previous Error 1, i.e the value for the label print directory comes from the server 1 from where we took the database dump. so we need to edit path of the label print output directory with the server 2 path.

Connect to the MySQL. get into the database.

 Run the following query.

select RULE_DEF from os_print_rules where ACTIVITY_STATUS = 'Active';

...