[Koha] Need advice regarding removal of deleted biblio records

[Andy Boze]

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
> *jcoehoorn at york.edu <jcoehoorn at york.edu>*
> 
> *Please contact helpdesk at york.edu <helpdesk at 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 Tue, Jun 25, 2019 at 4:28 PM Paul A <paul.a at navalmarinearchive.com>
> 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
>> Koha at lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
> 

-- 
Andy Boze, Associate Librarian
University of Notre Dame
271H Hesburgh Library
(574) 631-8708