Patch database while upgrading zabbix 1.8 to 1.8.1 ??

[rrr]

Is it necessary to patch (mysql)-database while upgrading from zabbix 1.8 to 1.8.1 ??

[Alexei]

No, there no patch. Just build new binaries and upgrade front-end PHP files.

[markl]

Thanks... I was wondering that too.

Would it be possible to mention this sort of thing in the documentation as it suggests that database needed to be patched. Maybe some sort of upgrade path such as :

1.6 --> 1.8 - Major upgrade - db changes
1.8 --> 1.8.1 - Minor upgrade - no db changes
1.8.1 --> 1.8.x - and so on...

That way we know whether a db patch is required or not...

Cheers.

[tekknokrat]

What about the index recreating proposed in release notes?

Btw. there's a small typo:

DROP INDEX node_cksum_cksum_1;

should be

DROP INDEX node_cksum_1;

[kmradke]

Is there any way to easily "audit" the database? I went through a number of beta versions and I *think* I manually did all the upgrades, but I would like to be sure. I've seen some tools to compare database table formats, but I'm not enough of a db guy to know exactly what I should do.