Differences

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

--- servers:bsd:games:trinitycore_3.3.5_localhost [2026/04/23 20:24] – [Server Update] Sean Rhone
+++ servers:bsd:games:trinitycore_3.3.5_localhost [2026/04/24 04:19] (current) – [Database Back-up] Sean Rhone
@@ Line 216: / Line 216: @@
 # Connection
 BindIP = "127.0.0.1"
-LoginDatabaseInfo     = "127.0.0.1;../../mariadb.sock;authserver;x;authserver"
+LoginDatabaseInfo = "127.0.0.1;../../mariadb.sock;authserver;x;authserver"
-WorldDatabaseInfo     = "127.0.0.1;../../mariadb.sock;worldserver;x;worldserver"
+WorldDatabaseInfo = "127.0.0.1;../../mariadb.sock;worldserver;x;worldserver"
 CharacterDatabaseInfo = "127.0.0.1;../../mariadb.sock;characters;x;characters"
@@ Line 332: / Line 332: @@
 cd '/tmp'
+notify-send -i ~/'.wine/Icons/WoW-335-256.png' -t '2000' 'Backing-up WoW 3.3.5 Databases...'
 mariadbd-safe --no-watch --skip-syslog --datadir=$HOME/'Projects/TrinityCore-335/mariadb/database' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock'
@@ Line 341: / Line 343: @@
 mariadb-admin 'shutdown' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER
-notify-send -i ~/'.wine/Icons/WoW-335-256.png' -t '3000' 'WoW 3.3.5 Databases Backed-up Successfully to Downloads'
+notify-send -i ~/'.wine/Icons/WoW-335-256.png' -t '2000' 'WoW 3.3.5 Databases Backed-up Successfully to Downloads'
 # End</code>
   ~/'Projects/TrinityCore-335/scripts/localhost-databases-backup.sh'
+===== Database Maintenance =====
+  mkdir -p ~/'Projects/TrinityCore-335/scripts' && ee ~/'Projects/TrinityCore-335/scripts/localhost-database-maintenance.sh' && chmod +x ~/'Projects/TrinityCore-335/scripts/localhost-database-maintenance.sh'
+<code>
+#!/bin/sh
+cd '/tmp'
+notify-send -i ~/'.wine/Icons/WoW-335-256.png' -t '2000' 'Starting WoW 3.3.5 DB maintenance...'
+mariadbd-safe --no-watch --skip-syslog --datadir=$HOME/'Projects/TrinityCore-335/mariadb/database' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock'
+sleep '2'
+mariadb-check --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER -o -A -f -e --auto-repair
+mariadb-admin 'shutdown' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER
+notify-send -i ~/'.wine/Icons/WoW-335-256.png' -t '2000' 'WoW 3.3.5 DB maintenance complete'
+# End</code>
+  ~/'Projects/TrinityCore-335/scripts/localhost-database-maintenance.sh'
 ===== Server Start =====