[Koha] Step by Step process to delete records

Robin Sheat robin at catalyst.net.nz
Tue Jul 16 23:35:33 NZST 2013


Op 16/07/13 12:11, Vinod Kumar Mishra schreef:
> Dear All,
> 
> I wanted to delete all records, items, and member from the koha without chaning any configuration and settings so please let me know step by step process.

You need to go into the database and truncate the tables you don't want
the content of.

For example, to delete all items:

TRUNCATE items;
TRUNCATE deleted_items;

To delete biblios:

TRUNCATE biblioitems;
TRUNCATE biblio;
TRUNCATE deletedbiblioitems;
TRUNCATE deletedbiblio;

To delete issues and issues history:

TRUNCATE old_issues;
TRUNCATE issues;

To delete borrowers:

TRUNCATE borrowers;
TRUNCATE deletedborrowers;

If there's other data you want to remove, you'll have to work out the
table name and do the same thing.

-- 
Robin Sheat
Catalyst IT Ltd.
✆ +64 4 803 2204
GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D


More information about the Koha mailing list