[Koha] How to reset the database?

[Tonnesen Steve]

On Wed, 30 Oct 2002, Jim Thomas wrote:

> We have just installed Koha on a PC in my school's library.  Now we're
> ready to start using it, but before we start inputting the collection,
> we need to delete the sample data from the database.  I couldn't find
> anything on the koha site describing how to do this, so I'm asking here.
> 
> How do we empty the database?


Use these instructions with great care!  This assumes that you are running
version 1.2 of Koha...


Connect to your koha database

mysql Koha -pROOTPASSWORD

or use the "user" and "password" settings from /etc/koha.conf with:

mysql Koha -uUSER -pPASSWORD

then run:

delete from items;
delete from biblioitems;
delete from bibliosubject;
delete from bibliosubtitle;
delete from additionalauthors;
delete from biblio;
delete from issues;



Steve Tonnesen.