Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
cloudappliance/database-troubleshooting [2018_07_11 17:06] – [Starting the Database] stevencloudappliance/database-troubleshooting [2018_07_11 17:17] – [Backups] steven
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 <code>smestorage</code> and stores data in MyISAM tables.+The File Fabric database is named **smestorage** and stores data in of InnoDB and MyISAM tables.
  
 For more information see https://mariadb.com/kb/en/library/backup-and-restore-overview/ For more information see https://mariadb.com/kb/en/library/backup-and-restore-overview/
Line 230: Line 230:
     * MySQL (be sure to pause mariadb via systemctl)     * MySQL (be sure to pause mariadb via systemctl)
  
-      * RENAME TABLE us\_logs TO us\_logs\_date2018; CREATE TABLE us\_logs LIKE us_logs_date2018;+      * RENAME TABLE us\_logs TO us\_logs\_date2018; CREATE TABLE us\_logs LIKE us\_logs\_date2018;
  
    * MySQL    * MySQL
Line 236: Line 236:
     * TRUNCATE us\_logs;     * TRUNCATE us\_logs;
  
-  * **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)