Documentation Center

Restoring a database using loaddb RESTORE

This procedure restores SDL LiveContent Reach databases that you have previously backed up either through the automated or manual process.

Before you begin

Backups can be restored to another system, even if the system that you restore the backup to has a different operating system than the computer on which the backup was created.

If the backup to be restored includes user information and credentials collection (/db/system), you must know the admin password at the time the database was backed up, as that password will be restored during the restore procedure.

About this task

The loaddb...RESTORE command restores the contents of a backed up file or folder, whether it was a full database backup or a backup of a sub-collection of a database. However, when restoring a full database backup, we recommend that you
  1. delete the existing database. See Deleting the database.
  2. restore the backup using the eXist client in embedded mode. See Restoring the database using eXist (embedded).

The loaddb...RESTORE command uses same xmlrpc connection to the database that loaddb...BACKUP uses, and it shares the same protocol constraint: it cannot be run over https.

This procedure restores the backed-up database. Although it is possible to restore to a remote system, using the -Dlc.host argument, we do not recommend that you do so.

Procedure

  1. If you are restoring a full database backup, we recommend you delete the existing database first. See Deleting the database.
  2. At a command navigate to the Tomcat\webapps\LiveContent\WEB-INF folder (Tomcat/webapps/LiveContent/WEB-INF on Linux).
    loaddb.{bat,sh} -Dlc.host=FQDN -Dlc.port=port_number 
    -Dlc.context=/LiveContent -Dlc.file=folder/file.zip RESTORE
    where:
    OptionDescription
    -Dlc.host Host name of the SDL LiveContent Reach instance to connect to. The default is localhost.
    -Dlc.portNon-SSL port number to connect to. Defaults to 8080. The default is derived from the local configuration.
    -Dlc.contextSDL LiveContent Reach context. The default is derived from local configuration, usually /LiveContent
    -Dlc.filePath and file or folder name where the backup file is located. The default is backup.zip. For example: C:\backup\06152010.zip