Re: [Koha] Delete all the books record

2019-11-09 Thread 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  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@lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Delete all the books record

2019-11-09 Thread Franz Dietrich
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@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha