Update/Migrate DB from 1.8.x to 2.0.x (new DB)

[scheuri]

Hi all

We have a node that is used for zabbix database (1.8.x) exclusively.
Now we would like to update to 2.0.x, preserving the configurations (that is a must) and if possible the data (not that important, but nice to have).

In the same run we would like to change the node (changing to new server with Ubuntu Server 12.04).

What I thought I would do is:

• Install new node and prepare MySQL for Zabbix 1.8.x
• Import the data (config and possible data) from the old node to new node
• Update the database from 1.8 to 2.0.x on new node
• Install server and web interface (2.0) on other nodes using the new database

Now, what I would like to know is:

1. Is it possible to directly import (and maybe data) 1.8 config to a 2.0 database (instead taking the route of upgrading the database after importing)?
2. If so, anyone got experience and some tipps how to do so?
3. If not, is the way I described above OK and feasible? Anyone some experience?

Thanks a lot for your response
Best regards
Stefan

[Eudald Valcarcel]

Hi, I'm also interested on these questions. We're working on a migration of our old zabbix1.8 to a new fresh server with 2.0.0

About the DB migration, as we want to maintain most of the data collected during this years, we would like to know the process to lose as less data as possible during.

Thanks in advance!
Eudald

[scheuri]

Hi there

What I am doing right now is:
Taking the whole database from 1.8.3 (my current productive DB) and import in my new server (ubuntu 12.04 64bit server with mysql).
Then I run the patch.sql from 2.0.0 (and now 2.0.1).

If that succeeds then I start to plan the downtime and the move from my old to the new server (including the upgrade to 2.0.1). In the meantime I can also install the server and the webgui on the new servers.

However, so far I have the following problem:

http://www.zabbix.com/forum/showthread.php?t=26906

[Eudald Valcarcel]

I see. I'm going to test it before smashing down anything...

It looks a bit primitive but, if there's no other way and it works... hehe.

Ty

[ballscout1]

Hi there

What I am doing right now is:
Taking the whole database from 1.8.3 (my current productive DB) and import in my new server (ubuntu 12.04 64bit server with mysql).
Then I run the patch.sql from 2.0.0 (and now 2.0.1).

If that succeeds then I start to plan the downtime and the move from my old to the new server (including the upgrade to 2.0.1). In the meantime I can also install the server and the webgui on the new servers.

However, so far I have the following problem:
http://www.zabbix.com/forum/showthread.php?t=26906

How exactly do you execute the patch. I want to try it for the same reasons.

we have a 1.86 zabbix server. We want to upgrade to 2.0.x

I have built the new 2.0.x server and it is functioning. The only thing being monitored on it as of now is itself.

I want to take the database from the 1.86 server and dump it ,move it over to the new server and patch it ...


What are the steps in order and what is the command to run the upgrade patch.