Appendix F. Resetting the Koha Database

Table of Contents

1. Truncate Tables
2. Reset the Zebra Index

These notes on how to reset the database for Koha 3 were derived from the following email thread: http://lists.koha-community.org/pipermail/koha-devel/2009-January/008939.html

Resetting the database may be useful if you install Koha with the sample data, and then wish to use real data without reinstalling the software.

1. Truncate Tables

Use your preferred MySQL client to truncate the following tables:

  • bibio

  • biblioitems

  • items

  • auth_header

  • sessions

  • zebraqueue