Differences

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

--- servers:bsd:games:trinitycore_3.3.5_localhost [2025/10/26 14:00] – [Database Back-up] Sean Rhone
+++ servers:bsd:games:trinitycore_3.3.5_localhost [2025/12/03 13:10] (current) – [Information] Sean Rhone
@@ Line 2: / Line 2: @@
   * TrinityCore
-  * [[https://talk.trinitycore.org/t/singleplayer-scripts-and-desktop-start-launchers-on-windows-linux-freebsd/33293|TrinityCore Forums]]
+  * [[https://talk.trinitycore.org/t/singleplayer-scripts-and-desktop-start-launchers-on-windows-linux-freebsd/33293/7|TrinityCore Forums]]
   * These notes provide a local single-player server for World of Warcraft 3.3.5
@@ Line 18: / Line 18: @@
   * https://trinitycore.info/install/requirements/linux
-  * :?: May require a ''boost'' package ((''keepassxc'' pulls in ''boost-libs''))
   su -
-  pkg install git readline mariadb118-client mariadb118-server cmake-core bzip2 libressl
+  pkg install git readline mariadb118-client mariadb118-server cmake-core libressl
   exit
@@ Line 65: / Line 64: @@
 ===== Initial Setup =====
-==== Server Start ====
+  * Change the root password: ''N''
-****
+  mariadbd-safe --no-watch --skip-syslog --datadir=$HOME/'Projects/TrinityCore-335/mariadb/database' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock'
-  mariadbd-safe --datadir=$HOME/'Projects/TrinityCore-335/mariadb/database' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock'
-==== Set-up ====
-  * Separate Terminal window
-  * Change the root password: ''N''
   mariadb-secure-installation --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER
@@ Line 86: / Line 78: @@
 ===== Connect =====
-  mariadbd-safe --datadir=$HOME/'Projects/TrinityCore-335/mariadb/database' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock'
+  mariadbd-safe --no-watch --skip-syslog --datadir=$HOME/'Projects/TrinityCore-335/mariadb/database' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock'
   mariadb --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER
@@ Line 151: / Line 143: @@
 ===== MMaps =====
-  * :!: ~30 minutes i5-8400H ((2025/10/25: ''28 Minutes 14 Seconds'' at ''--threads 8''))
+  * :!: ~30 minutes i5-8400H ((2025/10/29: ''28 Minutes 11 Seconds'' at ''--threads 8''))
   * ''--threads $(nproc)''
@@ Line 177: / Line 169: @@
 ===== World Database =====
-==== TDB ====
   * https://trinitycore.info/en/install/Database-Installation#populating-the-mysql-trinity-databases
+==== TDB ====
   * https://github.com/TrinityCore/TrinityCore/releases
@@ Line 291: / Line 283: @@
   ~/'Projects/TrinityCore-335/scripts/localhost-worldserver-start.sh'
+===== Database Start =====
+  mkdir -p ~/'Projects/TrinityCore-335/scripts' && ee ~/'Projects/TrinityCore-335/scripts/localhost-database-start.sh' && chmod +x ~/'Projects/TrinityCore-335/scripts/localhost-database-start.sh'
+<code>
+#!/bin/sh
+mariadbd-safe --no-watch --skip-syslog --datadir=$HOME/'Projects/TrinityCore-335/mariadb/database' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock'
+# End</code>
+  ~/'Projects/TrinityCore-335/scripts/localhost-database-start.sh'
 ===== Server Update =====
@@ Line 299: / Line 304: @@
 #!/bin/sh
+git -C ~/'Projects/TrinityCore-335/src' reset --hard
 git -C ~/'Projects/TrinityCore-335/src' pull origin '3.3.5' --rebase
@@ Line 310: / Line 316: @@
 sleep '2'
-notify-send -i ~/'.wine/Icons/WoW-335-256.png' -t '2000' 'WoW 3.3.5 localhost server update complete'
+notify-send -i ~/'.wine/Icons/WoW-335-256.png' -t '3000' 'WoW 3.3.5 localhost server update complete'
 # End</code>
@@ Line 331: / Line 337: @@
 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 Databases Backed-up Successfully to Downloads'
+notify-send -i ~/'.wine/Icons/WoW-335-256.png' -t '3000' 'WoW 3.3.5 Databases Backed-up Successfully to Downloads'
 # End</code>
@@ Line 337: / Line 343: @@
   ~/'Projects/TrinityCore-335/scripts/localhost-databases-backup.sh'
-===== Database Start =====
+===== Server Start =====
-  mkdir -p ~/'Projects/TrinityCore-335/scripts' && ee ~/'Projects/TrinityCore-335/scripts/localhost-database-start.sh' && chmod +x ~/'Projects/TrinityCore-335/scripts/localhost-database-start.sh'
+  mkdir -p ~/'Projects/TrinityCore-335/scripts' && ee ~/'Projects/TrinityCore-335/scripts/localhost-server-start.sh' && chmod +x ~/'Projects/TrinityCore-335/scripts/localhost-server-start.sh'
-<code>
-#!/bin/sh
-mariadbd-safe --no-watch --skip-syslog --datadir=$HOME/'Projects/TrinityCore-335/mariadb/database' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock'
-# End</code>
-  ~/'Projects/TrinityCore-335/scripts/localhost-database-start.sh'
-===== Server Start (Desktop) =====
-  mkdir -p ~/'Projects/TrinityCore-335/scripts' && ee ~/'Projects/TrinityCore-335/scripts/localhost-server-start-desktop.sh' && chmod +x ~/'Projects/TrinityCore-335/scripts/localhost-server-start-desktop.sh'
 <code>
@@ Line 360: / Line 353: @@
 sleep '2'
-xfce4-terminal --minimize -T 'WoW 3.3.5 - [auth]' -I ~/'.wine/Icons/WoW-335-256.png' -e ~/'Projects/TrinityCore-335/scripts/localhost-authserver-start.sh' &
+xfce4-terminal --minimize -T 'WoW 3.3.5 [auth]' -I ~/'.wine/Icons/WoW-335-256.png' -e ~/'Projects/TrinityCore-335/scripts/localhost-authserver-start.sh' &
-xfce4-terminal --minimize -T 'WoW 3.3.5 - [world]' -I ~/'.wine/Icons/WoW-335-256.png' -e ~/'Projects/TrinityCore-335/scripts/localhost-worldserver-start.sh'
+xfce4-terminal --minimize -T 'WoW 3.3.5 [world]' -I ~/'.wine/Icons/WoW-335-256.png' -e ~/'Projects/TrinityCore-335/scripts/localhost-worldserver-start.sh'
 # End</code>
-  ~/'Projects/TrinityCore-335/scripts/localhost-server-start-desktop.sh'
+  ~/'Projects/TrinityCore-335/scripts/localhost-server-start.sh'
 ====== Create GM Account ======
@@ Line 413: / Line 406: @@
   * [[#databases|Initial set-up]]
-  mariadbd-safe --datadir=$HOME/'Projects/TrinityCore-335/mariadb/database' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock'
+==== authserver ====
-==== authserver ====
+  mariadbd-safe --no-watch --skip-syslog --datadir=$HOME/'Projects/TrinityCore-335/mariadb/database' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock'
   mariadb --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER --execute='CREATE DATABASE authserver;'
@@ Line 426: / Line 419: @@
   cat ~/'Downloads/'*'-WoW-335-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
 ====== Quick Commands ======
@@ Line 431: / Line 426: @@
 ===== DB Optimize =====
-  mariadbd-safe --datadir=$HOME/'Projects/TrinityCore-335/mariadb/database' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock'
+****
-  mariadb-check --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER -o -A -f -e --auto-repair
+  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
-===== Execute =====
+===== MariaDB Server =====
-==== MariaDB ====
+  * ''--no-watch'' runs as a background daemon
+  mariadbd-safe --skip-syslog --datadir=$HOME/'Projects/TrinityCore-335/mariadb/database' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock'
+  mariadbd-safe --no-watch --skip-syslog --datadir=$HOME/'Projects/TrinityCore-335/mariadb/database' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock'
+==== Stop ====
 ****
-  mariadbd-safe --datadir=$HOME/'Projects/TrinityCore-335/mariadb/database' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock'
+  mariadb-admin 'shutdown' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER
-==== authserver ====
+===== authserver =====
 ****
@@ Line 449: / Line 450: @@
   cd ~/'Projects/TrinityCore-335/run/bin' && ~/'Projects/TrinityCore-335/run/bin/authserver' --config-dir ~/'Projects/TrinityCore-335/authserver.conf.d'
-==== worldserver ====
+===== worldserver =====
 ****