Clearing/resting data
Issue #300
resolved
Is there a safe way to clear/purge everything while retaining all setting. Need this to test importing in from a clean, empty database/store
Comments (2)
-
repo owner
-
repo owner
- changed status to resolved
- Log in to comment
See Q9 in the FAQ. If you want to keep eg. users, domains, retention rules, etc. then don't drop the piler database, rather drop the following tables:
metadata, sph_counter, sph_index, attachment, tag, counter, counter_stats, and rcpt.
Then run the mysql < db-mysql.sql command (I'd backup the piler database in case something goes wrong)