LINUX, FOSS AND LIBRARY TECHNOLOGY ENTHUSIAST

Wednesday, January 30, 2019

Koha Instance Backup with [Date+Hour+Minute]

2 comments
While using Koha we may have to take database backup for safety. Why we take backup?. The main reason for data backup is to save important files if a system crash or hard drive failure occurs. If any natural or man-made disasters occur. in order to take Koha's MySQL database with date+hour+minutes just open terminal and execute this command.
                                         
Go to ---->Main menu--->Terminal OR simply press the keys together

Ctrl+Alt+T ---> Terminal

sudo su

Password will ask - provide your system password and execute this followed by your mysql root password


mysqldump -uroot -p koha_library | xz > koha_library-$(date +%d-%m-%Y-%H.%M).sql.xz

Password : (Your MySQL root password) and wait a few secondes

After finishing You will get a zipped SQL file in your home folder like:

koha_library-29-01-2019-16.11.sql.xz    thats it. extract the file. your backup is ready.

Thank You....

2 comments: