[Koha] Upgrading Koha from 3.06 to 3.14

[Dibyendra Hyoju]

Thank Robin and all for your response.

I tried the way Robin suggested and it worked, however I got the
following error while issuing the koha-mysql  instancename < sqlfile
command:

ERROR 1005 (HY000) at line 2752: Can't create table
'koha_library.letter' (errno: 150)

Also, I couldn't find the saved Koha reports after importing the
earlier Koha database. It is not a big issue as I can manually create
reports from the SQL.But I am wondering, why the saved reports were
not imported even after issuing koha-upgrade-schema command.

Apart from these issue, I found catalogues, holdings info and patron
information imported correctly. I quickly checked the circulation info
and I think it has also been imported.

Regards,
Dibyendra


On 3/28/14, Robin Sheat <robin at catalyst.net.nz> wrote:
> Paul A schreef op do 27-03-2014 om 09:36 [-0400]:
>> Perhaps not germane to this Koha question, but your suggestion "sudo
>> apt-get dist-upgrade" _may_ cause unintended consequences with the
>> o/s.
>
> It possibly will, though probably not. It will also not really upgrade
> koha, as it doesn't cover moving the data.
>
> My suggestion (and I've done this a few times) is to install Koha from
> the packages (already done), take a database dump of the old one using
> mysqldump, create an instance in the new install (koha-create), and then
> load the data into the new instance.
>
> This last part can be done with:
>
> sudo koha-mysql instancename < dumpfile.sql
>
> Then you can run:
>
> sudo koha-upgrade-schema instancename
>
> wait a while (if you have a lot of data and history), and you'll have an
> up-to-date installation.
>
> --
> Robin Sheat
> Catalyst IT Ltd.
> ✆ +64 4 803 2204
> GPG: 5FA7 4B49 1E4D CAA4 4C38  8505 77F5 B724 F871 3BDF
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
Dibyendra Hyoju