Search Knowledge Base and Documentation

Unknown macro: {kbsearch}

Versions Compared

Key

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

...

  1. Stop the iSymphony server. See Starting And Stopping The iSymphony Server.
  2. Create a temporary directory to perform the recovery.

    Code Block
    languagebash
    mkdir isdbrecovery
    cd isdbrecovery
    Note

    Do not create this directory anywhere inside the /opt/isymphony3 directory.

  3. Copy the h2 database jar into the recovery directory:

    Code Block
    languagebash
    cp /opt/isymphony3/server/modules/framework/shared/org.h2_1.3.169.jar .
  4. Copy the database file into the recovery directory:

    Code Block
    languagebash
    cp /opt/isymphony3/server/conf/servers/default/isymphony.h2.db .
    Info

    If you have Core Servers other than default you will need to replace default with the slug of the core server you are repairing the database for.

  5. Run the following command to export the database to an sql file:

    Code Block
    languagebash
    java -cp org.h2_1.3.169.jar org.h2.tools.Recover
  6. Create a sub directory to hold the old database:

    Code Block
    languagebash
    mkdir old
    mv isymphony.h2.db ./old
  7. Run the following command to create a new database from the sql file:

    Code Block
    languagebash
    java -cp org.h2_1.3.169.jar org.h2.tools.RunScript -url "jdbc:h2:./isymphony" -user admin -password admin -script isymphony.h2.sql
  8. Move the new database into place:

    Code Block
    languagebash
    mv isymphony.h2.db /opt/isymphony3/server/conf/servers/default/
    Info

    If you have Core Servers other than default you will need to replace default with the slug of the core server you are repairing the database for.

  9. Ensure that the new h2.db file has the same ownership and permissions as the original file.

  10. Restart iSymphony. See Starting And Stopping The iSymphony Server.