Manual Recovery Plan
You should take koha mysql database backup in regular basis.
You can take koha database backup by running the following command:
mysqldump -u root -pserver koha > your_desired_folder/koha.sql
Take your necessary opac databases and files backup.
You can up koha.sql file by running the following command:
mysql -u root -pserver koha < your_desired_folder/koha.sql