Updating to 5.0LTS | Where is database/mysql/double.sql

[KBlasz]

Hello, I am very new to updating applications like this on ubuntu 18.04.

i am trying to update to 5.0LTS from 4.0LTS but for the life of me i cannot find the mysql double patch file mentioned in the upgrade procedure
https://www.zabbix.com/documentation...rade_notes_500

Where exactly can i get this and also how is this installed?

Much appreciated!

[reedacus25]

I'm going to guess that

Please execute the appropriate patch (SQL file) for your database:

database/mysql/double.sql
database/postgresql/double.sql
database/oracle/double.sql

Means to use the sql scripts from the git source (which isn't plainly obvious)
https://github.com/zabbix/zabbix/tre...e/5.0/database

FYI that link is pinned to the 5.0 Release branch, not master, and would assume that that is the branch to be pulled from for this upgrade process.

Hope thats helpful.

[KBlasz]

You are my saviour! Thank you

[KBlasz]

For anyone wonder how the patch is applied on Ubuntu 18.04 MySQL. I saved the file to the user Home directory and ran this command

mysql -u USERNAME -p zabbix < double.sql

The change to the history column is not made right away btw, on the next succesfull start of zabbix 5.0 the database is processed so make sure you tail your log file for live progress.