See www.zabbix.com for the official Zabbix site.

How to/trunk db patches

From Zabbix.org
Jump to: navigation, search
Note: Manual database patches are not required anymore for Zabbix 2.1/2.2. See more about automatic database upgrading.

General information

This is a community maintained attempt at providing incremental database patches. Currently only patches for MySQL are provided.
Incremental upgrades have been tested for OpenSUSE 11.3, CentOS 5.5, FreeBSD 8.1, Slackware-current and Debian 6.0.3.

First of all read a README at http://www.zabbix.org/svn/zabbixorg/zabbix/upgrade_incremental/README

To obtain all incremental patches and scripts run:

 svn co http://www.zabbix.org/svn/zabbixorg/zabbix/upgrade_incremental/

Upgrades starting from some development release (trunk) to the latest trunk revision

If you've selected this way you have to follow it until the final release of Zabbix 2.0.0
Before the using script upgrade_incremental you have to prepare your database as described in the README file.

Here is an example.
If you going to perform upgrade from development release 1.9.3 please find a line "1.9.3 18740" in the "releases" file. Then your insert statement should be like this:

  mysql> insert into dbdata values ('dbversion', '18740');

Use similar way to upgrade from another development releases which are listed in the releases file.
Note: perform mentioned insert statement only once when you are starting to use this way!


Upgrades starting from some development release (trunk) to some development release (trunk)

You can generate cumulative incremental patch (SQL script) from one development release to another one using generate_version_patch script. See README above for details.
If you've selected this way you can follow it until the final release of Zabbix 2.0.0 or at some point you can jump to the way described above.

To use the script generate_version_patch you do NOT have to prepare your database as described in the README file.
But you have to manually follow the version of your database already upgraded to.

An example to upgrade from 1.9.5 to 1.9.8.
Please execute this command to generate a cumulative SQL script:

 $ ./generate_version_patch 1.9.5 1.9.8

Then you can execute the generated SQL script with such command:

shell> mysql -u<username> -p<password> zabbix < zabbix_incremental_patch_1.9.5-1.9.8.sql