Clean Database

    Activity

    To clean the activity records, login in to MySQL/MariaDB and use the following command:

    To clean the login records, login in to MySQL/MariaDB and use the following command:

    File Access

    2. DELETE FROM FileAudit WHERE to_days(now()) - to_days(timestamp) > 90;

    To clean the file update records, login in to MySQL/MariaDB and use the following command:

    Permisson

    2. DELETE FROM PermAudit WHERE to_days(now()) - to_days(timestamp) > 90;

    Since version 6.2, we offer command to clear outdated library records in Seahub database,
    e.g. records that are not deleted after a library is deleted. This is because users can restore a deleted library, so we can’t delete these records at library deleting time.