Table of Contents |
---|
...
- Log in to the server from which you want to take backup.
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" />
- Access the database using mysql -u<username> -p command
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..)
- 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.
Code Block | ||
---|---|---|
| ||
select * from os_cfg_props where name = 'data_dir'; |
...
Code Block | ||
---|---|---|
| ||
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.
Code Block | ||
---|---|---|
| ||
select RULE_DEF from os_print_rules where ACTIVITY_STATUS = 'Active'; |
...