Re: [Koha] Upgrading from Koha 17.11 to 18.11 --- anything to watch out for?
Hi Chris, It does not depend on the Koha version, but the MySQL/MariaDB version, please double check the wiki page. https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix Regards, Jonathan Le mar. 2 avr. 2019 à 02:58, Chris Brown a écrit : > > Hi Hector, > > Thank you for your advice -- I will keep it in mind. We plan to upgrade > over Easter when the libraries that we support will all be closed. I will > take a full snapshot of the server (virtual machine) first so we can roll > back if disaster strikes, and we already keep off-machine daily backups. > > Do I still need to apply the "auto increment fix" in 18.11? > > Chris Brown > > > On Mon, Apr 1, 2019 at 11:00 PM Hector Gonzalez wrote: > > > Hello, you should have a complete backup that you trust and know how to > > restore. Both the database and the host files. > > > > Also, if the upgrade includes your database server, the upgrade may fail, > > as the upgrade might turn mysql off and leave it off while other packages > > -like koha-common- get upgraded, and koha-common requires mysql to be up, > > in order to upgrade your database schema. Make sure your mysql/mariadb > > packages are upgraded before letting koha upgrade. > > > > Other than that, it should be that simple. > > > > Hector Gonzalez. > > > > > On Mar 31, 2019, at 1:09 PM, Chris Brown wrote: > > > > > > Hello, > > > > > > We are currently running Koha 17.11 (installed from Debian packages) on > > > Debian 9.3, and we want to upgrade to Koha 18.11 > > > > > > Is it really as simple as: > > > > > > sudo apt-get update > > > sudo apt-get upgrade > > > > > > or is there anything else I need to watch out for? For example, do I need > > > to take action to update the database schema? > > > > > > Best Regards, > > > > > > Chris Brown > > > ___ > > > Koha mailing list http://koha-community.org > > > Koha@lists.katipo.co.nz > > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > ___ > > Koha mailing list http://koha-community.org > > Koha@lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Upgrading from Koha 17.11 to 18.11 --- anything to watch out for?
Hi Hector, Thank you for your advice -- I will keep it in mind. We plan to upgrade over Easter when the libraries that we support will all be closed. I will take a full snapshot of the server (virtual machine) first so we can roll back if disaster strikes, and we already keep off-machine daily backups. Do I still need to apply the "auto increment fix" in 18.11? Chris Brown On Mon, Apr 1, 2019 at 11:00 PM Hector Gonzalez wrote: > Hello, you should have a complete backup that you trust and know how to > restore. Both the database and the host files. > > Also, if the upgrade includes your database server, the upgrade may fail, > as the upgrade might turn mysql off and leave it off while other packages > -like koha-common- get upgraded, and koha-common requires mysql to be up, > in order to upgrade your database schema. Make sure your mysql/mariadb > packages are upgraded before letting koha upgrade. > > Other than that, it should be that simple. > > Hector Gonzalez. > > > On Mar 31, 2019, at 1:09 PM, Chris Brown wrote: > > > > Hello, > > > > We are currently running Koha 17.11 (installed from Debian packages) on > > Debian 9.3, and we want to upgrade to Koha 18.11 > > > > Is it really as simple as: > > > > sudo apt-get update > > sudo apt-get upgrade > > > > or is there anything else I need to watch out for? For example, do I need > > to take action to update the database schema? > > > > Best Regards, > > > > Chris Brown > > ___ > > Koha mailing list http://koha-community.org > > Koha@lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Upgrading from Koha 17.11 to 18.11 --- anything to watch out for?
Hello, you should have a complete backup that you trust and know how to restore. Both the database and the host files. Also, if the upgrade includes your database server, the upgrade may fail, as the upgrade might turn mysql off and leave it off while other packages -like koha-common- get upgraded, and koha-common requires mysql to be up, in order to upgrade your database schema. Make sure your mysql/mariadb packages are upgraded before letting koha upgrade. Other than that, it should be that simple. Hector Gonzalez. > On Mar 31, 2019, at 1:09 PM, Chris Brown wrote: > > Hello, > > We are currently running Koha 17.11 (installed from Debian packages) on > Debian 9.3, and we want to upgrade to Koha 18.11 > > Is it really as simple as: > > sudo apt-get update > sudo apt-get upgrade > > or is there anything else I need to watch out for? For example, do I need > to take action to update the database schema? > > Best Regards, > > Chris Brown > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Upgrading from Koha 17.11 to 18.11 --- anything to watch out for?
Hello, We are currently running Koha 17.11 (installed from Debian packages) on Debian 9.3, and we want to upgrade to Koha 18.11 Is it really as simple as: sudo apt-get update sudo apt-get upgrade or is there anything else I need to watch out for? For example, do I need to take action to update the database schema? Best Regards, Chris Brown ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha