Avatar of Zerox Hoop
Zerox Hoop
Flag for India asked on

zabbix server backup issue

Hi Expert,

I've configured zabbix in ubuntu 12.04.Now it's working fine.
now i'm trying to take backup and restore backup in new zabbix machine.i've restored backup in new zabbix system.and when i was logging in browser than i've got below error.

    * Error in query [SELECT DISTINCT t.triggerid,t.value,t.lastchange,t.priority,t.value_flags,t.description,t.error, t.expression,hg.groupid FROM triggers t,functions f,items i,hosts_groups hg WHERE hg.hostid=i.hostid AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND hg.groupid IN ('2','4') AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND t.value='1' AND t.flags IN ('0','4') ORDER BY lastchange DESC,t.lastchange DESC] [Unknown column 't.value_flags' in 'field list']
   
 * Error in query [SELECT e.* FROM events e JOIN (SELECT max(eventid) as lasteventid FROM events e WHERE 1=0 AND e.objectid BETWEEN 000000000000000 AND 099999999999999 AND e.object=0 AND e.value_changed=1 GROUP BY e.objectid) ee ON e.eventid=ee.lasteventid] [Unknown column 'e.value_changed' in 'where clause']

Please suggest,what can we do in this situation.

Thanks & Regards,
xeroxzerox
Linux

Avatar of undefined
Last Comment
Zerox Hoop

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Mazdajai

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Zerox Hoop

ASKER
Thanks for response but Same issue facing .. same error i found in it.
i've successfully taken fullbackup and only configured setting backup from zabbix.
but issue in restore.may be some gap missing.
Mazdajai

How do you perform the restore?
Zerox Hoop

ASKER
http://zabbixzone.com/zabbix/backuping-full-database/

in this link in below script scribe to restore backup....
Your help has saved me hundreds of hours of internet surfing.
fblack61
Mazdajai

What version of zabbix? Can you post the mysql log?
Zerox Hoop

ASKER
Thanks...