zabbix upgrade to 2.0.6 issues

[rstogsdill]

I am coming from 1.0.8 to 2.0.6. I am currently trying to get the database updated.

6 Upgrade the database

Before you upgrade:

Make sure the database user has enough permissions (create table, drop table, create index, drop index)
Make sure you have enough free disk space.

Database upgrade scripts are located in the upgrades/dbpatches/2.0/<db engine> directory. Run the scripts:

MySQL: upgrades/dbpatches/2.0/mysql/patch.sql


How do you execute this patch? or the upgrade script? When I run ./upgrade from the folder after I hit "y" for yes it errors out and tells me it cant run as root but it never ask for user/pass. How do i feed it this info. Thanks in advance!

[Heilig]

You can't use these scripts. From documentation:
These scripts are only for upgrading Zabbix 1.8.x to 2.0! For upgrading from earlier versions first use upgrade scripts from Zabbix 1.6.x or Zabbix 1.8.x.
Look for here how to update from earlier Zabbix version.

Or you are upgrading from 1.8?

[rstogsdill]

Sorry about that. It is 1.8.

[Heilig]

Try:
cd <patch folder>/upgrades/dbpatches/2.0/mysql
mysql -u<username> -p<password> zabbix < patch.sql

[rstogsdill]

Yes.. I found that somewhere in the documentation. Thanks for your help... It is much appreciated.

[corsino]

How was your database upgrade? Here when I run the patch, it tooks more then 16 hours to finish. Is that normal? Is there any faster way?

Regards,