Delete Database Range
If you want to automatically delete data from all logaholic profiles at once, you can use the deleterange.php command line script.
You can find the script here:
logaholic/components/MaintenanceScripts/deleterange.php
This script should be started from the command line only. It will delete a date range for all profiles in your system. It is intended to be used as a script that can automatically keep you database size under control.
Usage:
php -q deleterange.php [months]
Example:
php -q deleterange.php 24
This will delete everything except the last 24 months of data
Edit the script to set extra settings.
Change what level of deletion you want by setting the $what variable inside the script:
- what = 1: only delete detail data from main table (recommended)
- what = 2: delete all
- what = 3: only delete from summary tables