Zabbix server migration

[Shiva]

Hi
We are planning to move the Zabbix server to a more powerful box. The existing server is Solaris and the new server is Redhat Enterprise Linux. I am planning to install the Zabbix server and import the MySQL database. However, the IP address of this new server is different. Would this create a problem?
Of course all zabbix agents will be re-configured to use the new IP. Again, would the previous history be retained?
Thanks

[dantheman]

As long as you move the entire database over the history will still be there. That's where all the values are stored. changing the IP the agents look to should be all you have to do...

[Alexei]

You may specify both old IP and new IP in agent configuration files (Server=IP1,IP2,...) to make upgrade fast and trouble free. The upgrate won't create any problems.

[Shiva]

Migration Successful...Almost

The migration went very smoothly. We are now on a shiny new server. We also used this opportunity to update the version to 1.1.4.
However, in the Graphs menu under Configuration, there are lots of errors. Here is a snapshot:

Error in query [select distinct t.description,h.host from triggers t,functions f,items i,hosts h where t.triggerid= and f.triggerid=t.triggerid and f.itemid=i.itemid and i.hostid=h.hostid] 
[You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and f.triggerid=t.triggerid and f.itemid=i.itemid and i.hostid=h.hostid' at line 1]
Error in query [select description from triggers where triggerid=] 
[You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
Error in query [select distinct t.description,h.host from triggers t,functions f,items i,hosts h where t.triggerid= and f.triggerid=t.triggerid and f.itemid=i.itemid and i.hostid=h.hostid] 
[You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and f.triggerid=t.triggerid and f.itemid=i.itemid and i.hostid=h.hostid' at line 1]

[robertsonstudios]

You may specify both old IP and new IP in agent configuration files (Server=IP1,IP2,...) to make upgrade fast and trouble free. The upgrate won't create any problems.

In doing this, would the agent send all data to two servers? So if two zabbix servers were available they would both get the information?

[remi]

I believe this allows zabbix_server connections to the agent from two different ip's (the old and the new zabbix box). Zabbix_server retrieves the data from the clients, they are not sending it.