Differences

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

--- servers:linux:games:trinitycore_3.3.5_localhost [2026/05/20 20:39] – manually import world-db Sean Rhone
+++ servers:linux:games:trinitycore_3.3.5_localhost [2026/05/30 21:35] (current) – [TDB] Sean Rhone
@@ Line 1: / Line 1: @@
 ====== Information ======
-  * TrinityCore ((https://www.trinitycore.org))
+  * TrinityCore
+  * ''3.3.5''
   * [[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
-  * For a traditional dedicated server see [[servers:linux:games:trinitycore_3.3.5|these notes]]
-  * :!: 2026/05/20: WIP
-===== Media =====
-  * [[https://www.youtube.com/watch?v=NaEoXA53tYM|localhost Server and Desktop Launcher Presentation Video]]
-  * [[https://media.realmofespionage.xyz/index/category/6|Progress Pics]]
-===== Resources =====
-  * [[https://trinitycore.org/|TrinityCore]]
-  * [[https://trinitycore.info/|TrinityCore MMo Project Wiki]]
 ===== Prerequisites =====
@@ Line 177: / Line 163: @@
   * https://github.com/TrinityCore/TrinityCore/releases
+  * Expects [[#databases|Initial DB set-up]]
   * Last tested: ''TDB_full_world_335.25101_2025_10_21.7z''
-z e -o'/tmp' -y ~/'Downloads/TDB_full_world_335.'*'.7z'
   mariadbd-safe --no-watch --skip-syslog --datadir=$HOME/'Projects/TrinityCore-335/mariadb/database' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock'
-  cat '/tmp/TDB_full_world_335.'*'.sql' | mariadb --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER 'worldserver'
+z e -o'/tmp' -y ~/'Downloads/TDB_full_world_335.'*'.7z' && cat '/tmp/TDB_full_world_335.'*'.sql' | mariadb --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER 'worldserver'
   mariadb-admin 'shutdown' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER
-  rm -Rf '/tmp/TDB_full_world_335.'*'.sql'
+  rm -f '/tmp/TDB_full_world_335.'*'.sql'
 ====== Settings ======
@@ Line 201: / Line 186: @@
   mkdir -p ~/'Projects/TrinityCore-335/authserver.conf.d' && nano ~/'Projects/TrinityCore-335/authserver.conf.d/localhost-authserver.conf'
-<code>[authserver]
+<code>
+[authserver]
 # Connection
@@ Line 333: / Line 319: @@
 cp -f ~/'Projects/TrinityCore-335/run/etc/worldserver.conf.dist' ~/'Projects/TrinityCore-335/run/etc/worldserver.conf'
-zenity --title 'WoW 3.3.5 Updater' --text 'localhost server update complete' --icon ~/'.wine/Icons/WoW-335-256.png' --timeout '3' --info
+zenity --title 'WoW 3.3.5 Updater' --text 'localhost server update complete' --icon ~/'.wine/Icons/WoW-335-256.png' --timeout '2' --info
 # End</code>
@@ Line 391: / Line 377: @@
 cd '/tmp'
+zenity --title 'WoW 3.3.5 (localhost)' --text 'Starting DB maintenance...' --icon ~/'.wine/Icons/WoW-335-256.png' --timeout '2' --info
 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-check --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER -o -A -f -e --auto-repair > '/dev/null'
 mariadb-admin 'shutdown' --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER
@@ Line 529: / Line 517: @@
   cd ~/'Projects/TrinityCore-335/run/bin' && ~/'Projects/TrinityCore-335/run/bin/worldserver' --config-dir ~/'Projects/TrinityCore-335/worldserver.conf.d'
+===== 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
 ===== DB Reset =====
   * ''DROP'' existing + ''CREATE'' + ''GRANT''
-  * [[#restore|Restore]] authserver/characters
+  * Restore [[#restore|authserver/characters]]
+  * Import [[#world_database|World DB]]
   mariadb --socket=$HOME/'Projects/TrinityCore-335/mariadb/mariadb.sock' --user=$USER --execute='DROP DATABASE authserver;DROP DATABASE characters;DROP DATABASE worldserver;CREATE DATABASE authserver;CREATE DATABASE characters;CREATE DATABASE worldserver;GRANT ALL PRIVILEGES ON authserver.* to 'authserver'@'localhost';GRANT ALL PRIVILEGES ON characters.* to 'characters'@'localhost';GRANT ALL PRIVILEGES ON worldserver.* to 'worldserver'@'localhost';FLUSH PRIVILEGES;'