Differences

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

--- servers:bsd:games:trinitycore_3.3.5_localhost [2026/04/23 19:03] – [Download Source] 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 316: / Line 316: @@
 cp -f ~/'Projects/TrinityCore-335/run/etc/authserver.conf.dist' ~/'Projects/TrinityCore-335/run/etc/authserver.conf'
 cp -f ~/'Projects/TrinityCore-335/run/etc/worldserver.conf.dist' ~/'Projects/TrinityCore-335/run/etc/worldserver.conf'
-sleep '2'
 notify-send -i ~/'.wine/Icons/WoW-335-256.png' -t '3000' 'WoW 3.3.5 localhost server update complete'
+read -p 'Done. Press Enter to exit.' 'x'
 # End</code>
@@ Line 331: / Line 330: @@
 <code>
 #!/bin/sh
+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'
 sleep '2'
-mariadb-dump --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER --single-transaction --quick 'authserver' -r $HOME/'Downloads/'$(date +%Y-%m-%d-%s)'-WoW-335-localhost-authserver.sql'
+mariadb-dump --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER --single-transaction --quick 'authserver' -r $HOME/'Downloads/'$(date +%Y-%m-%d-%s)'-localhost-authserver.sql'
-mariadb-dump --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER --single-transaction --quick 'characters' -r $HOME/'Downloads/'$(date +%Y-%m-%d-%s)'-WoW-335-localhost-characters.sql'
+mariadb-dump --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER --single-transaction --quick 'characters' -r $HOME/'Downloads/'$(date +%Y-%m-%d-%s)'-localhost-characters.sql'
 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 =====
@@ Line 353: / Line 380: @@
 #!/bin/sh
-mariadbd-safe --no-watch --skip-syslog --datadir=$HOME/'Projects/TrinityCore-335/mariadb/database' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock'
+cd '/tmp'
+xfce4-terminal --minimize -T 'WoW 3.3.5 [MariaDB]' -I ~/'.wine/Icons/WoW-335-256.png' -e ~/'Projects/TrinityCore-335/scripts/localhost-database-start.sh' &
 sleep '2'