We will create Tutorial on this topic till then you can refer the below given source for the steps to be followed for Koha data backup\r\n and restore.https://wiki.koha-community.org/wiki/Backing_up_Koha
1. If you want to take backup of biblios, authority you can export from super admin panel while Following on
Login using super librarian > Home > Tools > Export data > Export Bibliographic records/ authority Records.
it will download .mrc file which contains biblio data.
2. as mentioned above comment you can take a backup of database using mysqldump command as follow:
mysqldump -u databaseUser -p databasename > mykohabackup.sql (press entry)
it will ask you password please enter the database password
1. To Restore follow the following steps
Login using super librarian > Home > Tools > Stage MARC records for import
Upload your .mrc file once uploaded successfully click on manage the staged
wait till complete it.
2. To restoring database backup execute the following command:
mysql -u databaseUser -p databasename < mykohabackup.sql (press entry)
Note:make sure databasename should be same as instance name