Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
| cloudappliance/database-troubleshooting [2018_07_11 17:09] – [Backups] added mention of InnoDB steven | 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 161: | Line 161: | ||
| We typically recommend tools from the hypervisor or third-parties to backup the appliance and database. In some cases it’s helpful to use native tools. | We typically recommend tools from the hypervisor or third-parties to backup the appliance and database. In some cases it’s helpful to use native tools. | ||
| - | The File Fabric database is named `smestorage` and stores data in of InnoDB and MyISAM tables. | + | The File Fabric database is named **smestorage** and stores data in of InnoDB and MyISAM tables. |
| For more information see https:// | For more information see https:// | ||
| 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; | ||
| Line 307: | Line 307: | ||
| Remount | Remount | ||
| - | mount var/ | + | mount -a |
| + | |||
| Check new size | Check new size | ||