I would not do such partial loading, it won't work.
You're much better just loading the whole dump, replacing whatever
default database your 19.11 installation created.
Then manually run updatedatabase.pl or even simpler, follow the
instructions when connecting to Koha, it'll run the update from the UI.
This will be very fast.
Regards,
Philippe Blouin,
Directeur de la technologie
Tél. : (833) 465-4276, poste 230
philippe.blo...@inlibro.com <mailto:philippe.blo...@inlibro.com>
inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>
On 2020-05-14 10:16 a.m., Quỳnh Vũ Đỗ wrote:
Hello everyone
Our library has been using a Vietnamized version of Koha 3.18 since mid
2014, running on Ubuntu server 14.04 LTS. No upgrade of the system has been
made since and the server had a hardware problem (mainboard) last February.
We have a mysqldump of the Koha database (size about 1,8 GB).
So what we are trying to do is to install the latest Koha version (19.11)
on a fresh Ubuntu 16.04.6 LTS (Desktop) and then to replenish the empty
Koha tables through SQL inserts in the tables using sql exports of the
related fields from the old database. For that we have been comparing the
structure of the tables of Koha 3.18 and 19.11 with the tool provided at
http://schema.koha-community.org/
Can this way of proceeding, although tedious it might be, be successful or
not ?
If not, could someone have suggestions ?
Thanks for your attention.
Quynh
=================
M. Vũ Đỗ Quỳnh (Ph.D)
Trường Đại học Thăng Long - Université de Thang Long - Thang Long
University (Hanoi, Vietnam)
Phó Hiệu Trưởng, phụ trách HTQT - Vice-recteur chargé de la coopération
internationale - Vice-Rector in charge of International Cooperation
Web: http://thanglong.edu.vn/
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha