How to purge collected data in zabbix 2.0+

[connetport]

Hi,

I have Zabbix 2.0.4 and I want to delete all collected data (but not the configuration).

How can I achieve this ?

Best regards.

[Heilig]

You should delete data from "history*" and "trends*" tables. Also, you can clean up "alerts", "events", "auditlog" and a few other tables, but I'm not ready to give a complete list.

You can use statement:
DELETE FROM table_name;
or
TRUNCATE TABLE table_name;

Please make sure that you have a backup of the database, before deleting data.