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@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