Ad Widget

Collapse

Outdated data install SQL script?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • alj
    Senior Member
    • Aug 2006
    • 188

    #1

    Outdated data install SQL script?

    # mysql zabbix < /usr/share/zabbix/create/data.sql
    ERROR 1136 (21S01) at line 24: Column count doesn't match value count at row 1

    # sed -n -e 24p < /usr/share/zabbix/create/data.sql
    INSERT INTO config VALUES (1,365,365,600,'1-5,00:00-24:00');

    l# echo "describe config;" | mysql zabbix
    Field Type Null Key Default Extra
    configid bigint(20) unsigned NO PRI 0
    alert_history int(11) NO 0
    event_history int(11) NO 0
    refresh_unsupported int(11) NO 0
    work_period varchar(100) NO 1-5,00:00-24:00
    alert_usrgrpid bigint(20) unsigned NO 0


    #dpkg -l | grep zabbix-server
    ii zabbix-server-mysql 1.4.2-2 software for monitoring of your networks --
Working...