Differences

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

--- servers:bsd:games:trinitycore_3.3.5_localhost [2026/04/23 04:39] – Sean Rhone
+++ servers:bsd:games:trinitycore_3.3.5_localhost [2026/04/24 04:19] (current) – [Database Back-up] Sean Rhone
@@ Line 29: / Line 29: @@
   * https://github.com/TrinityCore/TrinityCore/commits/3.3.5/
-  cd ~ && mkdir -p ~/'Projects' && rm -Rf ~/'Projects/TrinityCore-335/src' && git clone --branch '3.3.5' --depth '1' --recurse-submodules 'https://github.com/TrinityCore/TrinityCore.git' ~/'Projects/TrinityCore-335/src'
+  mkdir -p ~/'Projects' && rm -Rf ~/'Projects/TrinityCore-335/src' && git clone --branch '3.3.5' --depth '1' --recurse-submodules 'https://github.com/TrinityCore/TrinityCore.git' ~/'Projects/TrinityCore-335/src'
 ====== Database ======
@@ Line 113: / Line 113: @@
   * https://trinitycore.info/en/install/Core-Installation/linux-core-installation
-  * :?: TODO: Check ''-DNDEBUG -w'' with Clang
-  rm -Rf ~/'Projects/TrinityCore-335/build' ~/'Projects/TrinityCore-335/run' && mkdir -p ~/'Projects/TrinityCore-335/build' ~/'Projects/TrinityCore-335/run' && cd ~/'Projects/TrinityCore-335/build' && cmake ~/'Projects/TrinityCore-335/src' -DCMAKE_INSTALL_PREFIX=~/'Projects/TrinityCore-335/run' -DCMAKE_BUILD_TYPE='Release' -DCMAKE_C_COMPILER='/usr/bin/clang' -DCMAKE_CXX_COMPILER='/usr/bin/clang++' -DCMAKE_CXX_FLAGS='-march=native -Ofast -DNDEBUG -w' -DWITHOUT_METRICS='1' -DTOOLS='1' && make -j "$(nproc)" install
+  rm -Rf ~/'Projects/TrinityCore-335/build' ~/'Projects/TrinityCore-335/run' && mkdir -p ~/'Projects/TrinityCore-335/build' ~/'Projects/TrinityCore-335/run' && cd ~/'Projects/TrinityCore-335/build' && cmake ~/'Projects/TrinityCore-335/src' -DCMAKE_INSTALL_PREFIX=~/'Projects/TrinityCore-335/run' -DCMAKE_BUILD_TYPE='Release' -DCMAKE_CXX_FLAGS='-w' -DWITHOUT_METRICS='1' -DTOOLS='1' && make -j "$(nproc)" install
 ====== Content ======
@@ Line 144: / Line 143: @@
 ===== MMaps =====
-  * :!: ~30 minutes i5-8400H ((2025/10/29: ''28 Minutes 11 Seconds'' at ''--threads 8''))
+  * :!: ~30 minutes i5-8400H ((2025/10/29: ''28 Minutes 11 Seconds'' 4C8T))
   * ''--threads $(nproc)''
@@ Line 173: / Line 172: @@
   ls ~/'Downloads/TDB_full_world_335.'*'.7z' && rm -f ~/'Projects/TrinityCore-335/run/bin/TDB_full_world_335.'*'.sql' && 7z e -o$HOME/'Projects/TrinityCore-335/run/bin' -y ~/'Downloads/TDB_full_world_335.'*'.7z'
+  rm -f ~/'Downloads/TDB_full_world_335.'*'.7z'
 ====== Settings ======
@@ Line 178: / Line 179: @@
 ===== authserver =====
-  * Last commit: [[https://github.com/TrinityCore/TrinityCore/commit/68bf7e6d12e1689d688db32c05066b8832922c67|Jul 28, 2021]] ''68bf7e6''
+  * Last commit: [[https://github.com/TrinityCore/TrinityCore/commit/440847c19346aaeb1e67297320db0eb51217f916|Apr 9, 2026]] ''440847c''
   * [[https://github.com/TrinityCore/TrinityCore/commits/3.3.5/src/server/authserver/authserver.conf.dist|New commits check]]
   * [[https://github.com/TrinityCore/TrinityCore/blob/3.3.5/src/server/authserver/authserver.conf.dist|Upstream authserver.conf.dist]] ([[https://raw.githubusercontent.com/TrinityCore/TrinityCore/3.3.5/src/server/authserver/authserver.conf.dist|raw]])
@@ Line 186: / Line 187: @@
   mkdir -p ~/'Projects/TrinityCore-335/authserver.conf.d' && ee ~/'Projects/TrinityCore-335/authserver.conf.d/localhost-authserver.conf'
-<code>[authserver]
+<code>
+[authserver]
 # Connection
 BindIP = "127.0.0.1"
 LoginDatabaseInfo = "127.0.0.1;../../mariadb.sock;authserver;x;authserver"
-AllowLoggingIPAddressesInDatabase = 0
 # Etc
+AllowLoggingIPAddressesInDatabase = 0
 Updates.EnableDatabases = 1
 Updates.CleanDeadRefMaxCount = -1
@@ Line 202: / Line 203: @@
 ===== worldserver =====
-  * Last commit: [[https://github.com/TrinityCore/TrinityCore/commit/0bd56da09b1f0ae34605a1a6fdd14ca26cd42d4c|June 10th, 2025]] ''0bd56da''
+  * Last commit: [[https://github.com/TrinityCore/TrinityCore/commit/440847c19346aaeb1e67297320db0eb51217f916|Apr 9, 2026]] ''440847c''
   * [[https://github.com/TrinityCore/TrinityCore/commits/3.3.5/src/server/worldserver/worldserver.conf.dist|New commits check]]
   * [[https://github.com/TrinityCore/TrinityCore/blob/3.3.5/src/server/worldserver/worldserver.conf.dist|Upstream worldserver.conf.dist]] ([[https://raw.githubusercontent.com/TrinityCore/TrinityCore/3.3.5/src/server/worldserver/worldserver.conf.dist|raw]])
@@ Line 215: / 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 286: / Line 287: @@
 #!/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'
+mariadbd-safe --skip-syslog --datadir=$HOME/'Projects/TrinityCore-335/mariadb/database' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock'
 # End</code>
@@ Line 298: / Line 301: @@
 <code>
 #!/bin/sh
+cd '/tmp'
 git -C ~/'Projects/TrinityCore-335/src' reset --hard
@@ Line 303: / Line 308: @@
 cd ~/'Projects/TrinityCore-335/build'
-cmake ~/'Projects/TrinityCore-335/src' -DCMAKE_INSTALL_PREFIX=~/'Projects/TrinityCore-335/run' -DCMAKE_BUILD_TYPE='Release' -DWITHOUT_METRICS='1' -DTOOLS='0'
+cmake ~/'Projects/TrinityCore-335/src' -DCMAKE_INSTALL_PREFIX=~/'Projects/TrinityCore-335/run' -DCMAKE_BUILD_TYPE='Release' -DCMAKE_CXX_FLAGS='-w' -DWITHOUT_METRICS='1' -DTOOLS='0'
 make -j "$(nproc)" install
+cd '/tmp'
 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 323: / 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 345: / 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'
@@ Line 407: / Line 444: @@
   mariadb --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER --execute='CREATE DATABASE authserver;'
-  cat ~/'Downloads/'*'-WoW-335-localhost-authserver.sql' | mariadb --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER 'authserver'
+  cat ~/'Downloads/'*'-localhost-authserver.sql' | mariadb --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER 'authserver'
 ==== characters ====
@@ Line 413: / Line 450: @@
   mariadb --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER --execute='CREATE DATABASE characters;'
-  cat ~/'Downloads/'*'-WoW-335-localhost-characters.sql' | mariadb --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER 'characters'
+  cat ~/'Downloads/'*'-localhost-characters.sql' | mariadb --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER 'characters'
   mariadb-admin 'shutdown' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER