You can back the holdings and biblio records in marc21 format.
You cannot backup circulation history, patron data, serials data,
acquisition settings, authorities, system settings, etc using just marc21.
Joel Coehoorn
Director of Information Technology
402.363.5603
*jcoeho...@york.edu <jcoeho...@york.edu>*
*Please contact helpd...@york.edu <helpd...@york.edu> for technical
assistance.*
The mission of York College is to transform lives through
Christ-centered education and to equip students for lifelong service to
God, family, and society
On Wed, Apr 17, 2019 at 12:13 PM Tsu-Shuan Chang <tschang.ucda...@gmail.com>
wrote:
> Response to: Please reply to the mailing list so that others can
> participate.
>
>
> I am new and have two questions.
>
> (1) Can we back up in MARC21 format? If yes, how?
>
> (2) Can we restore the data from above mentioned MARC21 format? If yes,
> how?
>
> I ask the questions since we have an old koha, maybe in version 1, running
> on Window XP and the computer is totally dead. If the above can be done, it
> is totally independent of the machine and database used. At least for small
> library, it should not take too much time to use the backup this way and
> recover the data no matter what database is used.
>
> By the way, has anyone the idea to recover the old data in our case?
>
> Thanks.
>
>
>
> On Wed, Apr 17, 2019 at 4:31 AM Owen Leonard <oleon...@myacpl.org> wrote:
>
> Please reply to the mailing list so that others can participate.
>
>
> > On Wed, Apr 17, 2019 at 12:25 AM Rizwan Majeed <rizwanmaj...@ue.edu.pk>
> > wrote:
> > >
> > > this is the query
> > >
> > > SELECT *
> > > FROM(SELECT
> > > items.dateaccessioned,
> > > items.barcode,
> > > items.itemcallnumber,
> > > biblio.title,
> > > biblio.author,
> > > biblioitems.publishercode,
> > > (SELECT
> >
> ExtractValue(biblioitems.marcxml,'//datafield[@tag="650"]/subfield[@code>="a"]'))
> > > AS Subject
> > > FROM items
> > > LEFT JOIN biblioitems ON
> > (items.biblioitemnumber=biblioitems.biblioitemnumber)
> > > LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
> > > WHERE items.dateaccessioned BETWEEN <<Between (yyyy-mm-dd)|date>> AND
> > <<and (yyyy-mm-dd)|date>>) AS t
> > > WHERE Subject LIKE concat('%',<<Subject>>,'%')
> > > ORDER BY dateaccessioned DESC
> > >
> > _______________________________________________
> > 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
