Is there a way to clear the mysql stats without restarting ntop? in particular, i would like to clear TCPrcvdFromRem from the IPtraffic table. If i do something like 'UPDATE IPtraffic SET TCPrcvdFromRem=NULL where IPaddress like '192.168.0.%'; it doesnt really clear it properly. It will set it to NULL, but the next time data is written to that field, it continues off before inserting the NULL. Is there a command line possibly that clears stats? or any other way I can do this? ive developed a system where you log in to a webpage and it inserts your ip and username, logs stats and emails you at the end of the day the stats for each user. However, when you log out, I want to make it so that it clears the stats for that IP address and moves the TCPrcvdFromRem data to a Totals table, and in that table, you have the Username mapped with how much data they have downloaded. This part works fine, its just the IPaddress part that needs clearing. Any ideas? _______________________________________________ Ntop mailing list [EMAIL PROTECTED] http://lists.ntop.org/mailman/listinfo/ntop
