[Koha-bugs] [Bug 29910] Purge old Hea data periodically
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Mar 18 10:10:40 CET 2022
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29910
Jonathan Druart <jonathan.druart+koha at gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED
--- Comment #16 from Jonathan Druart <jonathan.druart+koha at gmail.com> ---
Added the following cronjob:
0 1 1 * * /usr/bin/mysqldump heastats | gzip > /home/hea/dumps/$(date
+%Y-%m-%d)-heastats.sql.gz && /usr/bin/mysql -e "DELETE FROM installation WHERE
modification_time < DATE_SUB(NOW(), INTERVAL 6 MONTH);"
It will dump the DB and remove all installations without changes in the last 6
months.
First (manual) run removed 6123 installations.
8744 still in DB.
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list