Logaholic.com Home  |  Knowledge Base  |  Support

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