[Koha] biblioitems

Robin Sheat robin at catalyst.net.nz
Mon May 30 15:00:43 NZST 2011

sysadmin schreef op zo 29-05-2011 om 19:28 [-0700]:
> I still wouldn't mind repairing the old corrupted database. If you
> could
> provide some info this 

Well, it depends on the nature of the backup, but I'm going to assume
it's an SQL dump.

Load it into another MySQL database (on the same instance as the koha
you're setting up, ideally.) Find the range of biblio numbers that are
missing, and using mysql's ability to select and insert across
databases, pull all the things across that have a biblionumber within
the corrupted range. You'll want to pull from the tables 'biblio',
'biblioitems', 'items'.

Robin Sheat
Catalyst IT Ltd.
✆ +64 4 803 2204
GPG: 5957 6D23 8B16 EFAB FEF8  7175 14D3 6485 A99C EB6D
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
Url : http://lists.katipo.co.nz/pipermail/koha/attachments/20110530/9ff1f588/attachment.pgp 

More information about the Koha mailing list