LIS Links Becoming More Social

LIS Links Mailing List (Broadcast Message)

Birthdays

Birthdays Today

Latest Activity

THAKKAR VIVEK RAJESHKUMAR might attend Nagappa Veerappa Bakkannanavar's event

Invitation to Present | SoFerence 2026: A Global Platform to Showcase AI Use Cases in Libraries at Virtual

September 10, 2026 from 9:30am to 5pm
5 hours ago
0 Comments
Dr.Nishant Kumar Pandey updated their profile
7 hours ago
Richa Bismiter shared Chinmayee Bhange's event on Facebook
Thumbnail

5 days Librarian Development Program: Empowering Librarians for the Digital Future

7 hours ago
Dr. Badan Barman is now friends with NILARANJAN BARIK, BMS PUBLISHING HOUSE, Mahadev Ghosh and Abhishek Singh
yesterday
Ananya Sarkar updated their profile
yesterday
Dr. Prabhat Ranjan and Dr. Pramod kumar are now friends
yesterday
Dr. Rupali M. Phule updated their profile
yesterday
M S M Shiham updated their profile
Wednesday
Sumedha Singh posted an event
Thumbnail

Call for Paper for Libra World: The International Journal of Library and Information Technology (ISSN: 3139-1133) at online

August 1, 2026 at 6pm to August 20, 2026 at 7pm
Wednesday
0 Comments
Chinmayee Bhange posted events
Wednesday
Sumedha Singh posted a discussion

Call for Article for Libra World: The International Journal of Library and Information Technology (ISSN: 3139-1133)

Wednesday
0 Comments
Shravan Kumar Suppala updated their profile
Wednesday
Dr. Vikram Kr. Sharma updated their profile
Wednesday
Dr. U. PRAMANATHAN posted a discussion

National Librarian's Day-2026-Join the National movement and endorse the campaign with your voice and support.

Wednesday
0 Comments
Bonala Kondal updated their profile
Wednesday
Bonala Kondal and Dr. Badan Barman are now friends
Wednesday
sonali choudhury updated their profile
Wednesday
Medha Rajesh Mangurkar updated their profile
Wednesday
vasudev tiwari updated their profile
Tuesday
Monali Mitra Paladhi updated their profile
Tuesday

How to Take Backup in Koha 18.05

Dear Professionals,
Can I request you to kindly help me with "How to Take a Backup of Koha 18.05"? It is urgent.
Kind Regards,

Sugandha Bajaj.

Views: 618

▶ Reply to This

Replies to This Forum

Permalink Reply by Arvind Kant Singh on May 31, 2019 at 19:53

To get all the data, use:

mysqldump -u kohaadmin -p koha > mydatadump.sql

  • -u specifies the user to log in to MySQL as, in this case kohaadmin
  • -p makes mysqldump prompt for the password
  • koha is the name of the database
Permalink Reply by Vidya Sagar P V on June 3, 2019 at 21:26

To take a back up of your koha system, first you need the following information:

1. Mysql username and password.

Normally the username is root and password is whatever you have given at the time of installation.

Hope you have Ubuntu as operating system:

Open a Terminal and type : sudo su

enter the password:

After entering the password you will be in your desktop: 

mysql

It will take you to mysql prompt.

show databases;

this will show all the databases. notedown the name of your koha instance. Normally it will be koha_library

use koha_library;

database changed message will appear.

mysqldump -u root -p koha_library >koha_library_backup.sql;

(> this arrow is important)

enter your password:

here enter the mysql password.

Depending upon the site of the database, it takes some time to finish.

(the power button of the computer will be blinking continuously because it is working in the background.)

Once it is finished, the prompt will appear.

exit

to close the terminal.

all mentioned in bold letters are commands to bee typed on the terminal.

On your desktop you will see koha_library_backup.sql; (that is the name we have given to the backup file)

 

Permalink Reply by Vijender Kumar on July 22, 2022 at 7:01

RSS

© 2026   Created by Dr. Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

LIS Links whatsApp