Re: [Koha] After Upgrade no biblio_metadata and mo marcxml

[Liz Rea]

Hi,

Koha, by default, runs backups of the database every night and keeps 2
copies in /var/spool/koha/ * gevos (gelinger...@yandex.com) wrote:
>> Overyesterday We have updated ubuntu server and the koha was updated
>> too.
>> Apparently because of the mysql 5.7 the script somehow failed and we
>> have
>> landed to a point where only from 30.000 books only 2 books landed to
>> the
>> book_metadata.  and we don't have  now the original column marcxml in
>> biblioitems  :(
>
> All you can do is restore from your backup I am afraid
>
> Chris
>>
>>
>>
>> -- 
>> View this message in context:
>> http://koha.1045719.n5.nabble.com/After-Upgrade-no-biblio-metadata-and-mo-marcxml-tp5941726.html
>> Sent from the Koha-general mailing list archive at Nabble.com.
>> ___
>> 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

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7



signature.asc
Description: OpenPGP digital signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] After Upgrade no biblio_metadata and mo marcxml

[Chris Cormack]

* gevos (gelinger...@yandex.com) wrote:

Overyesterday We have updated ubuntu server and the koha was updated too.
Apparently because of the mysql 5.7 the script somehow failed and we have
landed to a point where only from 30.000 books only 2 books landed to the
book_metadata.  and we don't have  now the original column marcxml in
biblioitems  :(


All you can do is restore from your backup I am afraid

Chris




--
View this message in context: 
http://koha.1045719.n5.nabble.com/After-Upgrade-no-biblio-metadata-and-mo-marcxml-tp5941726.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


--
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand


signature.asc
Description: PGP signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] After Upgrade no biblio_metadata and mo marcxml

[Jonathan Druart]

Hi,

What is the exact error you got?

Regards,
Jonathan

On Tue, 1 Aug 2017 at 04:07 gevos  wrote:

> Overyesterday We have updated ubuntu server and the koha was updated too.
> Apparently because of the mysql 5.7 the script somehow failed and we have
> landed to a point where only from 30.000 books only 2 books landed to the
> book_metadata.  and we don't have  now the original column marcxml in
> biblioitems  :(
>
>
>
> --
> View this message in context:
> http://koha.1045719.n5.nabble.com/After-Upgrade-no-biblio-metadata-and-mo-marcxml-tp5941726.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> ___
> 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

Re: [Koha] After Upgrade no biblio_metadata and mo marcxml

[Josef Moravec]

it should theoretically work, but i didn't try it... note, that in mysql
tables biblio and biblioitems aren't all data, which are normally in
Marcxml record... co the MARC will be incomplete! but if you do not have
backup, you don't have many options...

Josef

út 1. 8. 2017 v 11:26 odesílatel Gevork Grigorian 
napsal:

> The problem is that I have no backup :(( I mentioned
> that the only problem is this missing MARCXML. From that XML file most of
> the things are in normal mysql table exists. Am I right? Only the IDs and
> Location fields are not there.
>
> Am I right? If i write a script which will generate the XML from the
> existing data , and put in the biblio_metadata database, it will work?
>
> 01.08.2017, 10:48, "Josef Moravec" :
>
> Hello,
>
> just reload db from backup, then set mysql according to this guide:
> https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04_and_MySQL_5.7
>
> then you can update your database structure and everything should be ok
>
> regards
> Josef
>
> út 1. 8. 2017 v 9:08 odesílatel gevos  napsal:
>
> Overyesterday We have updated ubuntu server and the koha was updated too.
> Apparently because of the mysql 5.7 the script somehow failed and we have
> landed to a point where only from 30.000 books only 2 books landed to the
> book_metadata.  and we don't have  now the original column marcxml in
> biblioitems  :(
>
>
>
> --
> View this message in context:
> http://koha.1045719.n5.nabble.com/After-Upgrade-no-biblio-metadata-and-mo-marcxml-tp5941726.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> ___
> 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

[Koha] After Upgrade no biblio_metadata and mo marcxml

[gevos]

Overyesterday We have updated ubuntu server and the koha was updated too. 
Apparently because of the mysql 5.7 the script somehow failed and we have
landed to a point where only from 30.000 books only 2 books landed to the
book_metadata.  and we don't have  now the original column marcxml in
biblioitems  :(



--
View this message in context: 
http://koha.1045719.n5.nabble.com/After-Upgrade-no-biblio-metadata-and-mo-marcxml-tp5941726.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] After Upgrade no biblio_metadata and mo marcxml

[Josef Moravec]

Hello,

just reload db from backup, then set mysql according to this guide:
https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04_and_MySQL_5.7

then you can update your database structure and everything should be ok

regards
Josef

út 1. 8. 2017 v 9:08 odesílatel gevos  napsal:

> Overyesterday We have updated ubuntu server and the koha was updated too.
> Apparently because of the mysql 5.7 the script somehow failed and we have
> landed to a point where only from 30.000 books only 2 books landed to the
> book_metadata.  and we don't have  now the original column marcxml in
> biblioitems  :(
>
>
>
> --
> View this message in context:
> http://koha.1045719.n5.nabble.com/After-Upgrade-no-biblio-metadata-and-mo-marcxml-tp5941726.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> ___
> 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