Komari清理数据库 - Leuの小站

前言#

komari 在随着使用的时间数据库占用硬盘的大小也在随之增加利用sqlite3 来清理数据库大小

1
apt install sqlite3

1
systemctl stop komari.service

防止修改数据库出现问题修改前请备份防止数据丢失

1
cp /opt/komari/data/komari.db /opt/komari/data/komaribf.db

1
sqlite3 /opt/komari/data/komari.db

1
sqlite3 /opt/komari/data/komari.db "DELETE FROM records; DELETE FROM records_long_term; DELETE FROM ping_records; VACUUM;"

1
DELETE FROM records;

1
DELETE FROM records_long_term;

1
DELETE FROM ping_records;

1
VACUUM;

1
.exit

1
systemctl restart komari.service