[Koha] How to wipe the database of books (on a test site)

[Robin Sheat]

magmatic schreef op ma 18-11-2013 om 08:17 [-0800]:
> I'm playing around with importing books into a test site, and I want
> to wipe
> the database ("delete from TABLE"), to start over.

It depends on exactly what you want to delete, but if it's just biblios:

items
biblioitems
biblio

(in that order should be the fastest.)

If you just do a delete, don't forget to reset the auto_increment back
to 1, or new things will be numbered from where the previous data left
off.

-- 
Robin Sheat
Catalyst IT Ltd.
✆ +64 4 803 2204
GPG: 5FA7 4B49 1E4D CAA4 4C38  8505 77F5 B724 F871 3BDF