🧹 AgriNex Data Cleanup

⚠️ Preview Mode

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

Retention Period: 180 days

Cut-off Date: 2025-10-05 15:50:32

📊 Records to be Deleted:

Table	Records	Action
json_backup	0 records	DELETE WHERE backup_timestamp < 2025-10-05 15:50:32
getdata_logs	0 records	DELETE WHERE waktu_mulai < 2025-10-05 15:50:32
sensor_weather_data	0 records	DELETE WHERE received_at < 2025-10-05 15:50:32
sensor_node_data	0 records	DELETE WHERE received_at < 2025-10-05 15:50:32
node_logs	0 records	DELETE WHERE waktu < 2025-10-05 15:50:32
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 180 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://www.suratuniku.my.id/api_v2/cleanup.php?days=90&confirm=yes" >> cleanup.log 2>&1