[Koha] Need advice regarding removal of deleted biblio records

[Paul A]

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.
>