Moving from MySQL on Localhost to dedicated server...

[macaulay]

I've been using Zabbix for around a year now, monitoring around 90 hosts (2000 or so items). All has been fine until recently where the zabbix vm started running out of space.

Long story short; i have set up a second MySQL only box to sit alongside the zabbix instance. I have transferred the db from localhost to the new box ( using

mysqldump -u USERNAME zabbix > db_backup.sql

and

mysql -uUSERNAME -h NEW_MYSQLBOX -pPSWD zabbix < db_backup.sql

and changed DBHost in zabbix-server.conf however i'm not seeing any new data?

A suitable user has been created in the new DB and amended in the conf file. I can

mysqladmin -u USERNAME -h NEW_MYSQLBOX -pPSWD status

and connect to new db.

Have I missed a step?
Thanks in advance (all logs available by request).
Mac

[joergi]

Hi Mac,

It looks like that you missed to change the $DB['SERVER'] in the zabbix.conf.php of the web frontend.

Regards,
Jörg

[macaulay]

That could be it!

I only found references to that file from about 2009 so I assumed (#sound of open palm slappining forehead#) it was relevant to v1.8.x series...

i'll have a look and report back...

[macaulay]

That was it.

Thanks for the swift reply, here; have a picture of cat. It will appease the gods of the internet...