[Koha-devel] Synchronizing a Koha database with kohastructure.sql (Bug 34064)
David Cook
dcook at prosentient.com.au
Tue Jun 20 06:36:00 CEST 2023
Hi all,
I think we've all encountered issues with a Koha database being out of sync
with kohastructure.sql, and it's not a fun experience to have. Today, I ran
into items.paidfor columns that have survived long past a 20.11.00 upgrade.
While looking to resolve that across all my instances, I was thinking how
there could be other quirks as well, so I thought it would be nice to have
an audit script:
"Bug 34064 - Compare kohastructure.sql against current database using
database audit script"
It's not 100% perfect, but it does a very good job of detecting differences
between a live Koha database and kohastructure.sql, and provides suggestions
on how to remedy the database.
It could be further improved, but I'm quite happy with this first draft. I'd
like to be able to run it using koha-foreach to get a sense of how in-sync
my Koha databases are on a server.
David Cook
Senior Software Engineer
Prosentient Systems
Suite 7.03
6a Glen St
Milsons Point NSW 2061
Australia
Office: 02 9212 0899
Online: 02 8005 0595
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20230620/1e3d84aa/attachment.htm>
More information about the Koha-devel
mailing list