Thanks, Joel.
I've been considering that. We do have a backup from immediately before
the failed import. There have been some records added by our catalogers
since then, but I think I can pretty easily identify them. I was just
hoping there'd be an easy way to purge the deleted biblio records.
Andy
On 6/25/19 5:47 PM, Coehoorn, Joel wrote:
To clarify the "Go back to previous backup" idea... assuming you have a
backup that will work, the normal challenge here is circulation
transactions that took place since the bad import. This often means running
and printing an issues report before restoring, and then manually
re-entering the circulation from the impacted period, with correct due
dates, etc. If there's a lot of traffic through the library, this can be a
real pain, but it shouldn't be a problem at all for a non-circulating
library. If you don't have backups, this is the reminder that you should be
taking them.
Joel Coehoorn
Director of Information Technology
402.363.5603
*[email protected] <[email protected]>*
*Please contact [email protected] <[email protected]> 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 Tue, Jun 25, 2019 at 4:28 PM Paul A <[email protected]>
wrote:
On 2019-06-25 4:43 p.m., Andy Boze wrote:
Dear all,
I'm hoping someone can give me a bit of direction. We have a large
number of deleted biblio records (due to a failed MARC records import).
We'd like to remove the deleted records from the database as there are
somewhat more deleted records (401,000) than active records.
Why not go back to your previous backup? Quick, simple, painless.
Best -- Paul
Is there a script than can clean up deleted records? I've seen this
"Clean up database" script <
https://koha-community.org/manual/18.11/en/html/cron_jobs.html#clean-up-database
>, but it's not what we're looking for.
If there's no script, can we safely use the MySQL TRUNCATE command on
the deletedbiblio, deletedbiblio_metadata, deletedbiblioitems and
deleteditems tables? This is a non-circulating library, so I don't think
the biblionumber would be tied to any other tables.
I'll appreciate any guidance. We're using Koha 18.11 and MariaDB 5.5.60.
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
--
Andy Boze, Associate Librarian
University of Notre Dame
271H Hesburgh Library
(574) 631-8708
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
