Moving Zabbix to another server?

[jmcnulty]

I have Zabbix 1.6.1 running currently on an RHEL 4.7 system with mysql-4.1.22-2 installed. This is the production box.

I want to move it to a new server running RHEL 5.2 with mysql-5.0.45-7 installed. I've already installed and configured Zabbix 1.6.1 on the new server, and given it a single client to look at just to prove it all works.

Are the steps involved as simple as this, or am I missing something that's going to bite me in the ass? :D

1. Stop Zabbix on the new and old servers
2. On the old server: mysqldump -u root -p zabbix > zab.dmp
3. Copy the dump file over to the new server
4. On the new server: mysql -u root -p zabbix < zab.dmp
5. Start Zabbix on the new server

I'm guessing I'm missing a step here, in that I'll have to delete the (test) zabbix database on the new server first? Are the differences in mysql versions going to cause me a problem?

Thanks .. John

[bbrendon]

Thats pretty much it. I would do some checking in the database since you're switching from mysql v4 to v5. Also, a test dump/import before hand would be useful if this is a major outage.

Don't forget if you have scripts/agents/trapd sending info to zabbix you need to update dns/IP.

[jmcnulty]

Hi. Well it all went well. Just had to drop the zabbix database in mysql on the new node and re-create it as an empty database before loading the dump file.

I'd already anticipated the possible need to move Zabbix one day, so I'd set up a dedicated IP address for it which was up on eth0:0 on the old box. I just moved that over to the new while the database was loading, then changed the SourceIP and ListenIP addresses in zabbix_server.conf before starting the server again.

It's running fine :)

Thanks for the reply. Always good to sanity check these things first.

John