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 *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 Tue, Jun 25, 2019 at 4:28 PM Paul A <pau...@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@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