How to delete all the records at once?

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

How to delete all the records at once?

dawg0x0
Hello,

how do i delete the records?
is there any option for deleting all the records at once.?



thank you


_______________________________________________
Koha mailing list
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: How to delete all the records at once?

Koustubha Kale
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 <[hidden email]>
Hello,

how do i delete the records?
is there any option for deleting all the records at once.?



thank you


_______________________________________________
Koha mailing list
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha



_______________________________________________
Koha mailing list
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: How to delete all the records at once?

Rick Welykochy
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
_______________________________________________
Koha mailing list
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: How to delete all the records at once?

Richard Anderson-3
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: [hidden email] | http://www.katipo.co.nz
Ph: (04) 934 1285 | Mob: 021 280 1504
Fax: (04) 934 1286

_______________________________________________
Koha mailing list
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha