[Koha] Delete all the books record

[takan bhatt]

What I does is

*sudo su*
*mysql -uroot -p*
*use koha_library;*

Then applied

*SET FOREIGN_KEY_CHECKS=0;*

*TRUNCATE items; *
*TRUNCATE deleteditems;*

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


*SET FOREIGN_KEY_CHECKS=1;*
*Quit*

*However, I think I have not reindexed zebra.*

*Kindly di help*

*Rajesh Bhatt*


On Sat, Nov 9, 2019, 18:53 Franz Dietrich <dietrich at teilgedanken.de> wrote:

> Most of the time it is easier to "just undo the import" which is
> possible on the import page. Since it sounds that you have already
> messed with the database you have to redo the zebra index:
>
> https://stackoverflow.com/questions/26925152/reindexing-zebra-because-there-are-no-results-found-in-opac-and-intranet-search
>
> If that did not help please elaborate and tell what you did already
>
> Am 09.11.19 um 13:02 schrieb takan bhatt:
> > Sir /Madam
> > During upload of marc file, I have made some mistake and my barcode is
> not
> > showing as it should be. Now I want to delete all the records. I tried
> > using an old blog. However, it is showing in catalogue search. I want to
> > completely remove all the records I uploaded.
> >
> >
> > Kindly help me.
> >
> > Rajesh Bhatt
> > GRIMS Vapi
> > _______________________________________________
> > Koha mailing list  http://koha-community.org
> > Koha at lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>