Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
cloudappliance/database-troubleshooting [2019_10_01 16:24] – fix remount command after resize eric | cloudappliance/database-troubleshooting [2021_07_01 14:42] – fixed mysql commands for rename/create & truncate which had us_logs for the or_logs section eric | ||
---|---|---|---|
Line 228: | Line 228: | ||
* Web File Manager (GUI) - Organization > Audit Logs > Clear Audit Logs (internally 500 at a time) | * Web File Manager (GUI) - Organization > Audit Logs > Clear Audit Logs (internally 500 at a time) | ||
- | * MySQL (be sure to pause mariadb via systemctl) | + | * MySQL (be sure to pause mariadb via systemctl)- Preserve Old Logs |
- | * RENAME TABLE us\_logs TO us\_logs\_date2018; CREATE TABLE us\_logs LIKE us\_logs\_date2018; | + | * RENAME TABLE or\_logs TO or\_logs\_date2021; CREATE TABLE or\_logs LIKE or\_logs\_date2021; |
- | * MySQL | + | * MySQL - Remove Old Logs |
- | * TRUNCATE | + | * TRUNCATE |
* **us\_logs** - Login audit log. Can be cleared: | * **us\_logs** - Login audit log. Can be cleared: | ||
- | * MySQL (be sure to pause mariadb via systemctl) | + | * MySQL (be sure to pause mariadb via systemctl))- Preserve Old Logs |
- | * RENAME TABLE us\_logs TO us\_logs\_date2018; CREATE TABLE us\_logs LIKE us\_logs\_date2018; | + | * RENAME TABLE us\_logs TO us\_logs\_date2021; CREATE TABLE us\_logs LIKE us\_logs\_date2021; |
- | * MySQL | + | * MySQL - Remove Old Logs |
* TRUNCATE us\_logs; | * TRUNCATE us\_logs; |