IS it possible to change zabbix server_id without loosing all historical data?

[vitaly_il]

I changed server_id on my zabbix server (1.4.5-1) and converted DB after that.
But when I started zabbix again it loose all historical data.
Is there some way to preserve all historical data when I change server_id?

thanks!

[xs-]

theoretically it's possible, but . . . you'd have to manually modify all *id fields in all tables.
Not something you actually wanna do.

[Alexei]

Probably you forgot to set NodeID in zabbix_server.conf, or the NodeID does not match the one set by -n <nodeid>.

[vitaly_il]

I did it as following:
1) changed node_id to 1
vi /etc/zabbix/zabbix_server.conf

2)cd /usr/sbin/
[root@zabbix sbin]# ./zabbix_server -n 1 -c /etc/zabbix/zabbix_server.conf

3) restarted zabbix

as result I I see only new data...

[xs-]

You can only modify a database (and afaik this only goes for unused, out-of-the-box, 'schema.sql+data.sql+images.sql') from no node-id to an initial node-id.
You cant change the node-id on a zabbix server which already has been converted at some point (without manually converting all id and related fields).

[vitaly_il]

>and afaik this only goes for unused, out-of-the->box, 'schema.sql+data.sql+images.sql'

This is probably an explanation of my problem.
But this is strange - what if I'm running a standalone Zabbix and some day want to add proxy server? it should be nice to have such possibility.