Problem with Flowview after reboot

[lasylve]

Hi,

I'm using flowview (0.6) plugin with cacti and everything seems to work fine except that when I reboot my server, the devices I registered in flowview are deleted.
After I added a new device the table plugin_flowview_devices is updated correctly but if I reboot (or restart mysql) the entry in the table is deleted.
Can someone help me with that issue please ?

[mcutting]

Check to see if these tables are memory based. If they are, then the contents will get deleted after a reboot.

[lasylve]

OK, that's it with a "show table status ;" I can see my plugin_flowview_devices table's type is MEMORY and after I input
"alter table plugin_flowview_devices type = MyISAM" devices are kept registered after a reboot.

Thank you very much mcutting.

I have now another question : how can I make the file flowview.sql create a table plugin_flowview_devices in MyISAM ? I don't understand why it doesn't whereas the code is

CREATE TABLE plugin_flowview_devices (
id int(12) NOT NULL auto_increment,
name varchar(64) NOT NULL,
folder varchar(64) NOT NULL,
allowfrom varchar(32) NOT NULL default '0',
port int(12) NOT NULL,
nesting varchar(4) NOT NULL default '-1',
version varchar(12) NOT NULL default '5',
rotation int(12) NOT NULL default '1439',
expire int(3) NOT NULL default '7',
compression int(1) NOT NULL default '0',
PRIMARY KEY (id),
KEY folder (folder)
) TYPE=MyISAM;

[mcutting]

Take a look in the setup.php file. Chances are that it's being set to MEMORY there.