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 <ro...@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@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > -- Dibyendra Hyoju _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
