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] – [Prerequisites] stevencloudappliance/database-troubleshooting [2018_07_11 17:07] – [Database Tables] steven
Line 82: Line 82:
 Start the database on the machine hosting the database server: Start the database on the machine hosting the database server:
  
-    systemctl stop mariadb+    systemctl start mariadb
  
 ## Connecting across a Network ## Connecting across a Network
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)