Need help creating poller_item.MYD table

[rtyrell]

Mysql crashed and somehow the poller_item.MYD file got deleted. I have the database schema but I am not that familiar with Mysql. Can anyone post the sytax required to recreate the poller_item table?

Thank you,

-Rick

[rony]

Run the following query on the cacti database:

Code: Select all

CREATE TABLE poller_item (
  local_data_id mediumint(8) unsigned NOT NULL default '0',
  poller_id smallint(5) unsigned NOT NULL default '0',
  host_id mediumint(8) NOT NULL default '0',
  action tinyint(2) unsigned NOT NULL default '1',
  hostname varchar(250) NOT NULL default '',
  snmp_community varchar(100) NOT NULL default '',
  snmp_version tinyint(1) unsigned NOT NULL default '0',
  snmp_username varchar(50) NOT NULL default '',
  snmp_password varchar(50) NOT NULL default '',
  snmp_port mediumint(5) unsigned NOT NULL default '161',
  snmp_timeout mediumint(8) unsigned NOT NULL default '0',
  rrd_name varchar(19) NOT NULL default '',
  rrd_path varchar(255) NOT NULL default '',
  rrd_num tinyint(2) unsigned NOT NULL default '0',
  rrd_step mediumint(8) unsigned NOT NULL default '300',
  rrd_next_step mediumint(8) NOT NULL default '0',
  arg1 varchar(255) default NULL,
  arg2 varchar(255) default NULL,
  arg3 varchar(255) default NULL,
  PRIMARY KEY  (local_data_id,rrd_name),
  KEY local_data_id (local_data_id),
  KEY host_id (host_id)
) TYPE=MyISAM;

After the table is created, you need to repopulate it. This is done by running Utilities -> Clear Poller Cache in the web interface. This really doesn't clear it, it rebuilds it and shows the results.

[rtyrell]

You guys rock....thanks again! Everthing is working now.

-Rick