Database Backup
The Koha database must be backed up at frequent intervals to avoid data loss.There are certain steps to backup the database in koha.
Log in to the server using ssh (refer here)
Backup
The command for data backup,
$ mysqldump -u root -p koha > kohadata.sql
Restore
The command for data restore,
$ mysql -u root -p koha < kohadata.sql
provided we have a .sql data named kohadata.sql
For more details on data backup and restore, refer here