🧹 AgriNex Data Cleanup

⚠️ Preview Mode

This will show what data will be deleted if you proceed.

Retention Period: 90 days

Cut-off Date: 2026-01-03 15:50:33

📊 Records to be Deleted:

Table	Records	Action
json_backup	0 records	DELETE WHERE backup_timestamp < 2026-01-03 15:50:33
getdata_logs	0 records	DELETE WHERE waktu_mulai < 2026-01-03 15:50:33
sensor_weather_data	0 records	DELETE WHERE received_at < 2026-01-03 15:50:33
sensor_node_data	0 records	DELETE WHERE received_at < 2026-01-03 15:50:33
node_logs	0 records	DELETE WHERE waktu < 2026-01-03 15:50:33
TOTAL	0 records

📅 Date Range:

Oldest Record: N/A
Newest Record: N/A
Total Records: 0

✅ No Old Data Found

There are no records older than 90 days to delete.

All data is within the retention period.

💡 Recommendations:

Default retention: 90 days (recommended)
For production: 180 days (6 months)
For testing: 30 days (1 month)

Change retention period:

30 Days 60 Days 90 Days 180 Days

⏰ Setup Automatic Cleanup (Cron Job):

Add this to your crontab to run cleanup weekly:

# Run every Sunday at 2 AM
0 2 * * 0 php /home/surn4175/public_html/api_v2/cleanup.php days=90 confirm=yes >> /home/surn4175/public_html/api_v2/cleanup.log 2>&1

Or via web:

0 2 * * 0 curl "https://suratuniku.my.id/api_v2/cleanup.php?days=90&confirm=yes" >> cleanup.log 2>&1