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*

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: