Dear All, I wanted to delete all records, items, and member from the koha without chaning any configuration and settings so please let me know step by step process. Thanking You. With regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librarian@rediffmail.com : mishravk79@gmail.com
Op 16/07/13 12:11, Vinod Kumar Mishra schreef:
Dear All,
I wanted to delete all records, items, and member from the koha without chaning any configuration and settings so please let me know step by step process.
You need to go into the database and truncate the tables you don't want the content of. For example, to delete all items: TRUNCATE items; TRUNCATE deleted_items; To delete biblios: TRUNCATE biblioitems; TRUNCATE biblio; TRUNCATE deletedbiblioitems; TRUNCATE deletedbiblio; To delete issues and issues history: TRUNCATE old_issues; TRUNCATE issues; To delete borrowers: TRUNCATE borrowers; TRUNCATE deletedborrowers; If there's other data you want to remove, you'll have to work out the table name and do the same thing. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D
Greetings, Just to follow up a little more on what Robin said.
I wanted to delete all records, items, and member from the koha without [changing] any configuration and settings so please let me know step by step process.
The main configuration that is in the database is in the table called systempreferences, so that is a table you do not truncate. Since you didn't say if you cared about circulation rules and other types of configuration, this is likely why Robin suggested that you individually truncate tables related to various functionalities. Also, a list of tables and relationships nicely formatted can be found at http://schema.koha-community.org/. GPML, Mark Tompsett
i have tried this command but this is giving this kind of error ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key constraint (`koha_libnamal`.`items`, CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `koha_libnamal`.`biblioitems` (`biblioitemnumber`)) so please help me -- View this message in context: http://koha.1045719.n5.nabble.com/Step-by-Step-process-to-delete-records-tp5... Sent from the Koha-general mailing list archive at Nabble.com.
Op 24/07/13 09:12, malikaamir schreef:
i have tried this command but this is giving this kind of error
ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key constraint (`koha_libnamal`.`items`, CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `koha_libnamal`.`biblioitems` (`biblioitemnumber`))
so please help me
Oh yeah, I forgot that, that is a slightly annoying change in newer mysql. Run: SET FOREIGN_KEY_CHECKS=0; before the commands, and: SET FOREIGN_KEY_CHECKS=1; after it. If you want more information, putting that error into google results in some good explanations. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D
i have tried this command and this is working fine thanx but now the problem is that i have deleted all records from tables biblio, biblioitems, and items but they are still opening in catalog search and also showing in opac search so please tell me that how i delete that records even tables are empty -- View this message in context: http://koha.1045719.n5.nabble.com/Step-by-Step-process-to-delete-records-tp5... Sent from the Koha-general mailing list archive at Nabble.com.
Op 26/07/13 06:08, malikaamir schreef:
but now the problem is that i have deleted all records from tables biblio, biblioitems, and items but they are still opening in catalog search and also showing in opac search so please tell me that how i delete that records even tables are empty
You will need to do a full reindex of zebra. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D
thanx its working nice -- View this message in context: http://koha.1045719.n5.nabble.com/Step-by-Step-process-to-delete-records-tp5... Sent from the Koha-general mailing list archive at Nabble.com.
i have configured postfix for Email in koha it was working fine but now its to late to receive any kind of Email so plz can you help me -- View this message in context: http://koha.1045719.n5.nabble.com/Step-by-Step-process-to-delete-records-tp5... Sent from the Koha-general mailing list archive at Nabble.com.
On Tue, Jul 16, 2013 at 4:41 PM, Vinod Kumar Mishra <vinod_librarian@rediffmail.com> wrote:
I wanted to delete all records, items, and member from the koha without chaning any configuration and settings so please let me know step by step process.
You probably need to do more than that, esp. if you are trying to use a production Koha database as the template. A good starting point would be 1. http://schema.koha-community.org/ 2. http://manual.koha-community.org/3.12/en/resetkohadb.html hope this helps -- Indranil Das Gupta Phone : +91-98300-20971 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org
participants (5)
-
Indranil Das Gupta -
malikaamir -
Mark Tompsett -
Robin Sheat -
Vinod Kumar Mishra