How to Enable Export Database Tab In Koha Tools

The new version Koha comes without enabling export database function in koha tools by default. So in order to take a backup from the Graphical User Interface (GUI), we need to enable the function in the koha instance's config file. Then only we can have database dumps via the koha tool. 

Enable database and configuration dumps via Koha tools

1. Open the terminal and edit your Koha instance's config file using the following command.

sudo nano /etc/koha/sites/library/koha-conf.xml

Where "library" is the name of the koha instance for which I want to enable backups via tools (replace "library" with your instance name)

2. Scroll down around line 291 where it says

<!-- Enable the two followings to allow super librarians to download

      database and configuration dumps (respectively) from the Export

      tool -->

3. Enable database backups via tools by changing the line

 

<backup_db_via_tools>0</backup_db_via_tools>

<backup_db_via_tools>1</backup_db_via_tools>

( Note that we are simply changing "0" to "1" (from "off" to "on") 

4. Enable database backups via tools by changing the line

<backup_conf_via_tools>0</backup_conf_via_tools>

<backup_conf_via_tools>1</backup_conf_via_tools>

(Note that we are simply changing "0" to "1" (from "off" to "on")

5. Save your changes (if you are using nano editor, press control + O) and Reboot your system/server. Now go on to the next step

Backup your Koha Database and Configuration file via Koha Tools

1. Log into to koha administration interface on your web browser.

2. Go to Home > Tools

3. Click on Export Data

4. To export your database, click on Export Database > Select the Database > Download Database

5. To export your configuration file, click on Export Configuration File > Select the Configuration File > Download Configuration File

There you have done it. Now you can backup your database anytime you want.