How to restore the deleted records [Command line method]

When you delete a record, Koha doesn't immediately erase it from the database; it moves it to a deleted table. These are the tables where deleted records are stored: deletedbiblio, deletedbiblio_metadata, deletedbiblioitems, and deleteditems.

Find the deleted Information

Since the records are no longer in the main catalogue, you need to look in the trash tables. The best way to do this is to run a simple report.

Go to Reports > Guided Reports > Create from SQL.

Give it a name like Find Deleted Records.

Paste this SQL query to see everything in the trash: 

SELECT biblionumber, title, author FROM deletedbiblio

Run the report and find the biblionumber of the records you deleted. Only a few numbers, write those numbers down.

Move old Koha database to new installation

1. Backup of old Koha
Take the backup of your existing Koha database. Either you can make use a database kept in your pen drive otherwise you can apply following command to take the backup,

sudo mysqldump -uroot -p koha_library | xz > koha_library.sql.xz

Put MySQL root password, when it asks.

2. Install Koha
Follow the instructions in Koha wiki

3. Restoration of old Koha database to a new one

Remove the existing database in the new Koha installation

sudo mysql -uroot -p 

[Enter the Linux password and after that enter MySQL Root password]

drop database koha_library;

create database koha_library;

quit;

Copy your database backup from your pen drive to home folder.

Extract the backup file, the extension will be .sql

Then restore the old backup to the new Koha installation.

Database Restoration commands,

sudo mysql -uroot -p koha_library < koha_library.sql     

[Check name of your source Koha database] 

exit

koha_library - name of database in new installation

koha.sql - name of database in old installation

Enter the MySQL root password.

4. Upgrade Database Schema

Database schema of old Koha should upgrade to match with the new version. Apply following commands in a terminal one by one,

sudo service memcached restart

sudo koha-upgrade-schema library

5. Rebuild the Zebra Index.

Apply following command in a terminal,

sudo koha-rebuild-zebra -v -f library