How to delete all the records at once?
Hello, how do i delete the records? is there any option for deleting all the records at once.? thank you
Arun, If you have access to mysql via command line or phpmyadmin, "delete from biblioitems" and "delete from biblio" should do the trick. Regards, Koustubha Kale Anant Corporation Contact Details : Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w), Maharashtra, India, Pin : 400601. TeleFax : +91-22-21720108, +91-22-21720109 Mobile : +919820715876 Website : http://www.anantcorp.com Blog : http://www.anantcorp.com/blog/?author=2 2010/5/1 arun j <aj7700@gmail.com>
Hello,
how do i delete the records? is there any option for deleting all the records at once.?
thank you
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Koustubha Kale wrote:
If you have access to mysql via command line or phpmyadmin, "delete from biblioitems" and "delete from biblio" should do the trick.
The importmarcbiblio.pl script has a -d option, which advises that three tables should be deleted: biblio biblioitems items Don't forget the items table. This will give you a completely empty catalogue AFAIK. cheers rickw -- _________________________________ Rick Welykochy || Praxis Services When a distinguished but elderly scientist states that something is possible, he is almost certainly right. When he states that something is impossible, he is very probably wrong. -- Arthur C. Clarke
There's a nice page which describes what you have to do here - http://wiki.koha.org/doku.php?id=resetdatabasekoha3 On 1/05/2010 8:49 p.m., Rick Welykochy wrote:
Koustubha Kale wrote:
If you have access to mysql via command line or phpmyadmin, "delete from biblioitems" and "delete from biblio" should do the trick.
-- Richard Anderson | Business Development Manager Katipo Communications Ltd PO Box 12487 | Wellington | New Zealand Email: richard@katipo.co.nz | http://www.katipo.co.nz Ph: (04) 934 1285 | Mob: 021 280 1504 Fax: (04) 934 1286
participants (4)
-
arun j -
Koustubha Kale -
Richard Anderson -
Rick Welykochy