Differences

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

--- servers:bsd:games:trinitycore_3.3.5_localhost [2026/04/23 05:11] – 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 195: / Line 194: @@
 LoginDatabaseInfo = "127.0.0.1;../../mariadb.sock;authserver;x;authserver"
+# Etc
 AllowLoggingIPAddressesInDatabase = 0
-# Etc
 Updates.EnableDatabases = 1
 Updates.CleanDeadRefMaxCount = -1
@@ Line 218: / 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 289: / 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 301: / Line 301: @@
 <code>
 #!/bin/sh
+cd '/tmp'
 git -C ~/'Projects/TrinityCore-335/src' reset --hard
@@ Line 306: / 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 326: / 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 348: / 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'