Upgrade from 1.4.4 to 1.5.2 - MySQL Procedures

[bill.unger]

I have already gone through the upgrade once and the mysql portion failed... unfortunately, I didn't write down the error. I am now getting ready to go through the upgrade a 2nd time (had made a backup of the entire install prior) and am wondering what the correct mysql upgrade procedures are.

Do I simply need to go to the /upgrades/dbpatches/1.6/mysql directory and type the following?

# cat patches.sql | mysql -u<user> -p<pass> zabbix

Thanks in advance,
Bill

[bill.unger]

I just re-executed the upgrade and all seemed to work correctly this time. Here were my exact steps:

1. Download and unpack the 1.5.2 source

2. Though I have a backup of the entire VM ( I have Zabbix running virtualized ), I made a backup of the zabbix database: #mysqldump -u<user> -p<pass> zabbix > zabbixbackup.sql

3. Compiled/built the new zabbix server

4. Ran mysql upgrade scripts - instead of trying to cat patches.sql from the command line, I launched mysql shell and ran the scripts from within mysql

5. Recursively copied the new frontend to the web directory

All was good...

[cstackpole]

Thanks!

I have done straight builds so far but it is good to test the upgrade path. Maybe I should try sometime soon....