zabbix升级遇到的mysql问题

不再犹豫33

我最近将zabbix从2.2.2升级到2.4.4以后，数据库还是用原来的数据库(ver 14.14)，连接mysql时一直出现问题,如图所示
，当我重新建立一个数据库时可以正常连接，我看了两个数据库的表的个数不同。请教各位有什么意见可以帮我解决这个问题

kider

应该是要新安装后，zabbix才会自动升级数据库吧

看看过程：
5 Upgrade procedure

Overview

This section provides the steps required for a successful upgrade from Zabbix 2.2.x to 2.4.

Database upgrade to version 2.4 may take a long time.

Make sure to read upgrade notes before proceeding with the upgrade.
1 Stop Zabbix server

Stop Zabbix server to make sure that no new data is inserted into database.

2 Back up the existing Zabbix database

This is a very important step. Make sure that you have a backup of your database. It will help if the upgrade procedure fails (lack of disk space, power off, any unexpected problem).

3 Back up configuration files, PHP files and Zabbix binaries

Make a backup copy of Zabbix binaries, configuration files and PHP files.

4 Install new server binaries

You may use pre-compiled binaries or compile your own.

5 Review server configuration parameters

Some parameters of zabbix_server.conf might have changed from 2.2, new parameters added. You may want to review them.

Housekeeper is disabled after upgrading to Zabbix 2.4 from versions before 2.2. The desired housekeeper functionality should be checked and enabled manually in Administration → General → Housekeeper, if necessary.

6 Start new Zabbix binaries

Start new binaries. Check log files to see if the binaries have started successfully.

Zabbix server will automatically upgrade the database.

Before you start the server:

Make sure the database user has enough permissions (create table, drop table, create index, drop index)
Make sure you have enough free disk space.
Zabbix server will automatically upgrade the database only from Zabbix 2.0.x to 2.4. For upgrading from earlier versions consult Zabbix documentation for 2.0 and earlier.

7 Install new Zabbix web interface

Follow installation instructions.


官网升级手册地址：
https://www.zabbix.com/documenta ... nstallation/upgrade

2.4升级声明：
https://www.zabbix.com/documenta ... n/upgrade_notes_240