Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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
    languagexml
    titleUsername 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.

...