Skip to main content
Pentaho Documentation

Backup and Restore Pentaho Repositories

A complete backup and restore of your Business Analytics (BA) or Data Integration (DI) repositories can be done through either the command (cmd) window or with Rest APIs for BA

Backup and Restore the Pentaho BA Repository

The backup process exports all content from the BA repository and creates a .zip file, which includes:

  • Users and roles
  • All files (dashboards, reports, etc.)
  • Schedules
  • Data connections
  • Mondrian schemas
  • Metadata entries
  • A manifest file

All of your content is pulled from this .zip file when you restore the BA repository.

You must have appropriate administrator permissions on the server in order to perform a repository backup or restore.

Step 1: Backup the BA Repository

Backing up up your BA repository is done through the use of command line arguments. There are some example arguments below that you can customize for your particular server. 

If an argument is required for successful backup and has not been provided, the missing requirement is displayed in the cmd window. Backup results are also displayed in the window.

  1. Open a cmd window and point the directory to the install location of your running BA server.
  2. Use the import-export script with your arguments for backing up the repository.
  3. Press Enter.

Windows

import-export.bat --backup --url=http://localhost:8080/pentaho --username=admin --password=password --file-path=c:/home/Downloads/backup.zip --logfile=c:/temp/logfile.log

Linux

./import-export.sh --backup --url=http://localhost:8080/pentaho --username=admin --password=password --file-path=/home/Downloads/backup.zip --logfile=/temp/logfile.log

Step 2: Restore the BA Repository

Restoring your BA repository is also done through the use of command line arguments. The process for restoring both repositories is similar to the backup process, except for the differences shown in the examples below. These examples can be customized for your particular server. 

If an argument is required for successful restore and has not been provided, the missing requirement is displayed in the cmd window. Restore results are also displayed in the window.

  1. Open a terminal window and change the directory to the install location of your running BA server.
  2. Use the import-export script with your arguments for restoring the repository.
  3. Press Enter.

Windows

import-export.bat --restore --url=http://localhost:8080/pentaho --username=admin --password=password --file-path=c:/home/Downloads/backup.zip --overwrite=true --logfile=c:/temp/logfile.log

Linux

./import-export.sh --restore --url=http://localhost:8080/pentaho --username=admin --password=password --file-path=/home/Downloads/backup.zip --overwrite=true --logfile=/temp/logfile.log

Backup and Restore the Pentaho DI Repository

The backup process exports all content from the DI repository and creates a .zip file, which includes:

  • Users and roles
  • All files (.ktrs, .kjbs, etc.)
  • Schedules
  • Data connections
  • Mondrian schemas
  • Metadata entries
  • A manifest file

All of your content is pulled from this .zip file when you restore the DI repository.

You must have appropriate administrator permissions on the server in order to perform a repository backup or restore.

Step 1: Backup the DI Repository

Backing up up your DI repository is done through the use of command line arguments. There are some example arguments below that you can customize for your particular server. 

If an argument is required for successful backup and has not been provided, the missing requirement is displayed in the cmd window. Backup results are also displayed in the window.

  1. Open a cmd window and point the directory to the install location of your running DI server.
  2. Use the import-export script with your arguments for backing up the repository.
  3. Press Enter.

Windows

import-export.bat --backup --url=http://localhost:9080/pentaho-di --username=admin --password=password --file-path=c:/home/Downloads/backup.zip --logfile=c:/temp/logfile.log

Linux

./import-export.sh --backup --url=http://localhost:9080/pentaho-di --username=admin --password=password --file-path=/home/Downloads/backup.zip --logfile=/temp/logfile.log

Step 2: Restore the DI Repository

Restoring your DI repository is also done through the use of command line arguments. The process for restoring the repository is similar to the backup process, except for the differences shown in the examples below. These examples can be customized for your particular server. 

If an argument is required for successful restore and has not been provided, the missing requirement is displayed in the cmd window. Restore results are also displayed in the window.

  1. Open a terminal window and change the directory to the install location of your running DI server.
  2. Use the import-export script with your arguments for restoring the repository.
  3. Press Enter.

Windows

import-export.bat --restore --url=http://localhost:9080/pentaho-di --username=admin --password=password --file-path=c:/home/Downloads/backup.zip --overwrite=true --logfile=c:/temp/logfile.log

Linux

./import-export.sh --restore --url=http://localhost:9080/pentaho-di --username=admin --password=password --file-path=/home/Downloads/backup.zip --overwrite=true --logfile=/temp/logfile.log