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.
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.
Go to ---->Main menu--->Terminal OR simply press the keys together
Ctrl+Alt+T ---> Terminal
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
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....
really enjoyed this post. useful information shared.
ReplyDeleteOceanapart technologies - databackup & transfer
How To get my MySQL root password
ReplyDelete