Re: [Koha] Upgrading Koha from 3.06 to 3.14
At 11:25 AM 3/27/2014 +0000, Vinod Kumar Mishra wrote:
Dear, Please use the following commands one by one to upgrade to latest old stable version: 1. echo deb http://debian.koha-community.org/koha oldstable main | sudo tee /etc/apt/sources.list.d koha.list 2. wget -O- http://debian.koha-community.org/koha/gpg.asc | sudo apt-key add - 3. sudo apt-get update 4. sudo apt-get upgrade 5. sudo apt-get dist-upgrade
Perhaps not germane to this Koha question, but your suggestion "sudo apt-get dist-upgrade" _may_ cause unintended consequences with the o/s. Regards -- Paul
Not only will this routine upgrade all packages installed, but it is not what the original poster asked for. If I understand correctly, the scenario is either "now that we've tested the new version in a test installation, how do we go upgrading the older source-based installation, keeping the older hardware in place" or "will a recent by-packages installation automatically upgrade the older db once it is restored to the new machine?". To provide a useful note, may I add that I used to have a git-based 3.08 installation myself and restored its db to a packages-based 3.14 one with no real problems. Koha applied all needed modifications to the db schema to bring it up to 3.14 level. kind regards, MP On 27 Μαρ 2014, at 3:36 μ.μ., Paul A <paul.a@navalmarinearchive.com> wrote:
At 11:25 AM 3/27/2014 +0000, Vinod Kumar Mishra wrote:
Dear, Please use the following commands one by one to upgrade to latest old stable version: 1. echo deb http://debian.koha-community.org/koha oldstable main | sudo tee /etc/apt/sources.list.d koha.list 2. wget -O- http://debian.koha-community.org/koha/gpg.asc | sudo apt-key add - 3. sudo apt-get update 4. sudo apt-get upgrade 5. sudo apt-get dist-upgrade
Perhaps not germane to this Koha question, but your suggestion "sudo apt-get dist-upgrade" _may_ cause unintended consequences with the o/s.
Regards -- Paul
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
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
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
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.
You will have other hidden issues, it will have stopped at the letter
On 30 March 2014 23:00, Dibyendra Hyoju <dibyendra@gmail.com> wrote: table and not created tables after that (including the reports which you have noticed). You will to search what an error 150 is, and then try your import again fixing whatever you need to get the letter table to be created. Chris
Thanks Chris and all! I dropped all the database tables and imported the earlier 3.06 database and performed import and upgrade command and it worked perfectly! Regards, Dibyendra On 3/30/14, Chris Cormack <chris@bigballofwax.co.nz> wrote:
On 30 March 2014 23:00, Dibyendra Hyoju <dibyendra@gmail.com> wrote:
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.
You will have other hidden issues, it will have stopped at the letter table and not created tables after that (including the reports which you have noticed). You will to search what an error 150 is, and then try your import again fixing whatever you need to get the letter table to be created.
Chris _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Dibyendra Hyoju
participants (5)
-
Chris Cormack -
Dibyendra Hyoju -
Manos PETRIDIS -
Paul A -
Robin Sheat