{"id":2063,"date":"2019-06-28T10:58:48","date_gmt":"2019-06-28T05:28:48","guid":{"rendered":"http:\/\/blog.tenthplanet.in\/?p=2063"},"modified":"2026-03-03T10:14:08","modified_gmt":"2026-03-03T10:14:08","slug":"steps-to-backup-and-restore-pentaho-repository","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/blogs\/steps-to-backup-and-restore-pentaho-repository\/","title":{"rendered":"Steps to backup and restore Pentaho+ repository"},"content":{"rendered":"

Backup and Restore Database repository for Pentaho+ BA server<\/h3>\n

1. Exporting From DB repository:<\/h4>\n

a. Open a cmd window and point the directory to the install location of your running Pentaho+ BA server.
\nb. Use the import-export script with your arguments for backing up the repository.
\nc. Press Enter.<\/p>\n

Windows:<\/strong><\/p>\n

import-export.bat --backup --url=http:\/\/ip:8080\/pentaho --username=admin --password=password --file-path=c:\/home\/Downloads\/backup.zip --logfile=c:\/temp\/logfile.log<\/pre>\n
Linux:<\/strong><\/p>\n
.\/import-export.sh --backup --url=http:\/\/ip:8080\/pentaho --username=admin --password=password --file-path=\/home\/Downloads\/backup.zip --logfile=\/temp\/logfile.log<\/pre>\n
2. Importing to DB Repository<\/h4>\n
a. Open a terminal window and change the directory to the install location of your running Pentaho Plus BA server.
\nb. Use the import-export script with your arguments for restoring the repository.
\nc. Press Enter.<\/p>\n
Windows:<\/strong><\/p>\n
import-export.bat --restore --url=http:\/\/ip:8080\/pentaho --username=admin --password=password --file-path=c:\/home\/Downloads\/backup.zip --overwrite=true --logfile=c:\/temp\/logfile.log<\/pre>\n
Linux:<\/strong><\/p>\n
.\/import-export.sh --restore --url=http:\/\/192.168.0.140:8080\/pentaho --username=admin --password=password --file-path=\/home\/Downloads\/backup.zip --overwrite=true --logfile=\/temp\/logfile.log<\/pre>\n
Backup and Restore Database repository for Pentaho data integration<\/h3>\n
1. Exporting from DB Repository<\/h4>\n
a. Open a cmd window and point the directory to the install location of your running Pentaho+ DI server.
\nb. Use the import-export script with your arguments for backing up the repository.
\nc. Press Enter.<\/p>\n
Windows:<\/strong><\/p>\n
import-export.bat --backup --url=http:\/\/ip:port\/pentaho-di --username=admin --password=password --file-path=c:\/home\/Downloads\/backup.zip --logfile=c:\/temp\/logfile.log<\/pre>\n
Linux:<\/strong><\/p>\n
.\/import-export.sh --backup --url=http:\/\/ip:port\/pentaho-di --username=admin --password=password --file-path=\/home\/Downloads\/backup.zip --logfile=\/temp\/logfile.log<\/pre>\n
2. Importing to DB Repository<\/h4>\n
a. Open a terminal window and change the directory to the install location of your running Pentaho+ DI server.
\nb. Use the import-export script with your arguments for restoring the repository.
\nc. Press Enter.<\/p>\n
Windows:<\/strong><\/p>\n
import-export.bat --restore --url=http:\/\/ip:port\/pentaho-di --username=admin --password=password --file-path=c:\/home\/Downloads\/backup.zip --overwrite=true --logfile=c:\/temp\/logfile.log<\/pre>\n
Linux:<\/strong><\/p>\n
.\/import-export.sh --restore --url=http:\/\/ip:port\/pentaho-di --username=admin --password=password --file-path=\/home\/Downloads\/backup.zip --overwrite=true --logfile=\/temp\/logfile.log<\/pre>\n","protected":false},"excerpt":{"rendered":"
Pentaho Repository is an environment for collaborative analysis and ETL development. The necessity of backing up the pentaho repository helps to restore<\/p>\n","protected":false},"author":23,"featured_media":2079,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[424],"tags":[548,549,550],"class_list":["post-2063","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pentaho","tag-database","tag-pentaho-business-analytics","tag-pentaho-solution-respository"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts\/2063","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/comments?post=2063"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts\/2063\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/media\/2079"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/media?parent=2063"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/categories?post=2063"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/tags?post=2063"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}