User Tools

Site Tools


servers:windows:games:trinitycore_3.3.5_localhost

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
servers:windows:games:trinitycore_3.3.5_localhost [2026/05/30 00:25] – [CXX_FLAGS Info] Sean Rhoneservers:windows:games:trinitycore_3.3.5_localhost [2026/05/30 21:33] (current) – VS2026 looks good Sean Rhone
Line 1: Line 1:
 ====== Information ====== ====== Information ======
  
-  * TrinityCore ((https://www.trinitycore.org)) +  * TrinityCore 
-  * 3.3.5 ((https://github.com/TrinityCore/TrinityCore/tree/3.3.5))+  * ''3.3.5''
   * [[https://talk.trinitycore.org/t/singleplayer-scripts-and-desktop-start-launchers-on-windows-linux-freebsd/33293/7|TrinityCore Forums]]   * [[https://talk.trinitycore.org/t/singleplayer-scripts-and-desktop-start-launchers-on-windows-linux-freebsd/33293/7|TrinityCore Forums]]
- 
-===== Media ===== 
- 
-  * [[https://media.realmofespionage.xyz/index/category/6|Progress Pics]] 
- 
-===== Resources ===== 
- 
-  * [[https://trinitycore.info/|TrinityCore MMo Project Wiki]] 
  
 ===== Prerequisites ===== ===== Prerequisites =====
Line 24: Line 16:
   * https://trinitycore.info/en/install/requirements/windows   * https://trinitycore.info/en/install/requirements/windows
  
-===== Visual Studio 2022 =====+===== Visual Studio 2026 =====
  
-  * https://aka.ms/vs/17/release/vs_community.exe ([[https://forums.mydigitallife.net/threads/repository-everything-about-windows-rt-woa-v8-x-x-and-v10-arm.57362/page-73#post-1896981|source]])+  * https://aka.ms/vs/18/Stable/vs_community.exe ([[https://gist.github.com/Chenx221/6f4ed72cd785d80edb0bc50c9921daf7|source]])
  
-  "%SystemRoot%\System32\curl.exe" --output "%UserProfile%\Downloads\vs_community.exe" --location "https://aka.ms/vs/17/release/vs_community.exe" --progress-bar && "%UserProfile%\Downloads\vs_community.exe"+  "%SystemRoot%\System32\curl.exe" --output "%UserProfile%\Downloads\vs_community.exe" --location "https://aka.ms/vs/18/Stable/vs_community.exe" --progress-bar && "%UserProfile%\Downloads\vs_community.exe"
  
 ==== Required Components ==== ==== Required Components ====
  
   * Desktop development with C++ (C++ core desktop features)   * Desktop development with C++ (C++ core desktop features)
-  * MSVC v143 - VS 2022 C++ x64/x86 build tools (Latest) +  * MSVC Build Tools for x64/x86 (Latest) 
-  * Windows 11 SDK (10.0.26100.7705)+  * Windows 11 SDK (10.0.26100.8249)
  
   "%ProgramFiles(x86)%\Microsoft Visual Studio\Installer\setup.exe"   "%ProgramFiles(x86)%\Microsoft Visual Studio\Installer\setup.exe"
Line 40: Line 32:
 ===== Boost ===== ===== Boost =====
  
 +  * https://www.boost.org/releases/latest/
   * https://sourceforge.net/projects/boost/files/boost-binaries/ (Ctrl + F)   * https://sourceforge.net/projects/boost/files/boost-binaries/ (Ctrl + F)
-  * Last tested: ''boost_1_91_0-msvc-14.3-64.exe''+  * Last tested: ''boost_1_91_0-msvc-14.5-64.exe''
  
-  msvc-14.3-64+  msvc-14.5-64
  
 ===== CMake ===== ===== CMake =====
Line 49: Line 42:
   * https://cmake.org/files/dev/?C=M;O=D (Ctrl + F)   * https://cmake.org/files/dev/?C=M;O=D (Ctrl + F)
   * https://cmake.org/download/#dev   * https://cmake.org/download/#dev
-  * Last tested: ''cmake-4.3.20260522-g149e2b0-windows-x86_64.msi''+  * Last tested: ''cmake-4.3.20260529-g7f5d94e-windows-x86_64.msi''
  
   * ''[ ]'' Add CMake to the PATH environment variable   * ''[ ]'' Add CMake to the PATH environment variable
Line 99: Line 92:
 **** ****
  
-  "%ProgramFiles%\MariaDB 12.3\bin\mariadb-install-db.exe" --skip-networking --datadir="%UserProfile%\Projects\TrinityCore-335\mariadb\database" --config="%UserProfile%\Projects\TrinityCore-335\mariadb\custom.cnf"+  "%ProgramFiles%\MariaDB 13.0\bin\mariadb-install-db.exe" --skip-networking --datadir="%UserProfile%\Projects\TrinityCore-335\mariadb\database" --config="%UserProfile%\Projects\TrinityCore-335\mariadb\custom.cnf"
  
 ===== Connect ===== ===== Connect =====
  
-  "%ProgramFiles%\MariaDB 12.3\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock"+  "%ProgramFiles%\MariaDB 13.0\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock"
  
-  "%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock"+  "%ProgramFiles%\MariaDB 13.0\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock"
  
 ===== Databases ===== ===== Databases =====
Line 149: Line 142:
   * [[https://learn.microsoft.com/en-us/cpp/build/reference/guard-enable-control-flow-guard?view=msvc-170|/guard:cf-]]   * [[https://learn.microsoft.com/en-us/cpp/build/reference/guard-enable-control-flow-guard?view=msvc-170|/guard:cf-]]
  
-<code>"%ProgramFiles%\CMake\bin\cmake.exe" -S "%UserProfile%\Projects\TrinityCore-335\src" -B "%UserProfile%\Projects\TrinityCore-335\build" -G "Visual Studio 17 2022" --fresh -Wno-error="author" -DBOOST_ROOT="%SystemDrive%/local/boost_1_91_0" -DMYSQL_INCLUDE_DIR="%ProgramFiles%\MariaDB 12.3\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 12.3\lib\libmariadb.lib" -DNOJEM="1" -DSCRIPTS="static" -DUSE_COREPCH="0" -DUSE_SCRIPTPCH="0" -DCMAKE_CXX_FLAGS="/EHs /arch:AVX2 /favor:INTEL64 /Gz /Oy /GS- /guard:cf- /W0" -DWITHOUT_METRICS="1" -DTOOLS="1"</code> +<code>"%ProgramFiles%\CMake\bin\cmake.exe" -S "%UserProfile%\Projects\TrinityCore-335\src" -B "%UserProfile%\Projects\TrinityCore-335\build" -G "Visual Studio 18 2026" --fresh -Wno-error="author" -DBOOST_ROOT="%SystemDrive%/local/boost_1_91_0" -DMYSQL_INCLUDE_DIR="%ProgramFiles%\MariaDB 13.0\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 13.0\lib\libmariadb.lib" -DNOJEM="1" -DSCRIPTS="static" -DUSE_COREPCH="0" -DUSE_SCRIPTPCH="0" -DCMAKE_CXX_FLAGS="/EHs /arch:AVX2 /favor:INTEL64 /Gz /Oy /GS- /guard:cf- /W0" -DWITHOUT_METRICS="1" -DTOOLS="1"</code>
- +
-<code>"%ProgramFiles%\CMake\bin\cmake.exe" -S "%UserProfile%\Projects\TrinityCore-335\src" -B "%UserProfile%\Projects\TrinityCore-335\build" -G "Visual Studio 17 2022" --fresh -Wno-error="author" -DBOOST_ROOT="%SystemDrive%/local/boost_1_91_0" -DMYSQL_INCLUDE_DIR="%ProgramFiles%\MariaDB 13.0\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 13.0\lib\libmariadb.lib" -DNOJEM="1" -DSCRIPTS="static" -DUSE_COREPCH="0" -DUSE_SCRIPTPCH="0" -DCMAKE_CXX_FLAGS="/EHs /arch:AVX2 /favor:INTEL64 /Gz /Oy /GS- /guard:cf- /W0" -DWITHOUT_METRICS="1" -DTOOLS="1"</code>+
  
 ===== Compile ===== ===== Compile =====
  
-  * ~25 minutes i5-8400H ((2026/05/25: ''00:23:08.22'' 4C4T))+  * ~25 minutes i5-8400H ((2026/05/30: ''00:22:47.74'' 4C4T))
  
-<code>"%ProgramFiles%\Microsoft Visual Studio\2022\Community\MSBuild\Current\Bin\amd64\MSBuild.exe" "%UserProfile%\Projects\TrinityCore-335\build\ALL_BUILD.vcxproj" -target:"Rebuild" -property:"Configuration=Release" -maxCpuCount -nodeReuse:"False" -terminalLogger:"off"</code>+<code>"%ProgramFiles%\Microsoft Visual Studio\18\Community\MSBuild\Current\Bin\amd64\MSBuild.exe" "%UserProfile%\Projects\TrinityCore-335\build\ALL_BUILD.vcxproj" -target:"Rebuild" -property:"Configuration=Release" -maxCpuCount -nodeReuse:"False" -terminalLogger:"off"</code>
  
 ===== DLLs ===== ===== DLLs =====
  
-  COPY /Y "%ProgramFiles%\MariaDB 12.3\lib\libmariadb.dll" "%UserProfile%\Projects\TrinityCore-335\build\bin\Release"+  COPY /Y "%ProgramFiles%\MariaDB 13.0\lib\libmariadb.dll" "%UserProfile%\Projects\TrinityCore-335\build\bin\Release"
  
   COPY /Y "%ProgramFiles%\OpenSSL-Win64\bin\legacy.dll" "%UserProfile%\Projects\TrinityCore-335\build\bin\Release"   COPY /Y "%ProgramFiles%\OpenSSL-Win64\bin\legacy.dll" "%UserProfile%\Projects\TrinityCore-335\build\bin\Release"
Line 223: Line 214:
  
   * https://github.com/TrinityCore/TrinityCore/releases   * https://github.com/TrinityCore/TrinityCore/releases
-  * Expects [[windows:10#zip|7-Zip]]+  * Expects [[windows:10#zip|7-Zip]] and [[#databases|Initial DB set-up]]
   * Last tested: ''TDB_full_world_335.25101_2025_10_21.7z''   * Last tested: ''TDB_full_world_335.25101_2025_10_21.7z''
  
-  "%ProgramFiles%\MariaDB 12.3\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock"+  "%ProgramFiles%\MariaDB 13.0\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock"
  
-  "%ProgramFiles%\7-Zip\7z.exe" x "%UserProfile%\Downloads\TDB_full_world_335."*".7z" -o"%UserProfile%\Downloads" && MOVE /Y "%UserProfile%\Downloads\TDB_full_world_335."*".sql" "%UserProfile%\Downloads\TDB_full_world_335.sql" && "%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" "worldserver" < "%UserProfile%\Downloads\TDB_full_world_335.sql" && DEL /Q "%UserProfile%\Downloads\TDB_full_world_335."*".7z" "%UserProfile%\Downloads\TDB_full_world_335.sql"+  "%ProgramFiles%\7-Zip\7z.exe" x "%UserProfile%\Downloads\TDB_full_world_335."*".7z" -o"%UserProfile%\Downloads" && MOVE /Y "%UserProfile%\Downloads\TDB_full_world_335."*".sql" "%UserProfile%\Downloads\TDB_full_world_335.sql" && "%ProgramFiles%\MariaDB 13.0\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" "worldserver" < "%UserProfile%\Downloads\TDB_full_world_335.sql" && DEL /Q "%UserProfile%\Downloads\TDB_full_world_335."*".7z" "%UserProfile%\Downloads\TDB_full_world_335.sql"
  
 ====== Settings ====== ====== Settings ======
Line 247: Line 238:
 # Connection # Connection
 BindIP = "127.0.0.1" BindIP = "127.0.0.1"
-MySQLExecutable = "C:\Program Files\MariaDB 12.3\bin\mariadb.exe"+MySQLExecutable = "C:\Program Files\MariaDB 13.0\bin\mariadb.exe"
 AllowLoggingIPAddressesInDatabase = 0 AllowLoggingIPAddressesInDatabase = 0
  
Line 274: Line 265:
 # Connection # Connection
 BindIP = "127.0.0.1" BindIP = "127.0.0.1"
-MySQLExecutable = "C:\Program Files\MariaDB 12.3\bin\mariadb.exe"+MySQLExecutable = "C:\Program Files\MariaDB 13.0\bin\mariadb.exe"
 AllowLoggingIPAddressesInDatabase = 0 AllowLoggingIPAddressesInDatabase = 0
  
Line 341: Line 332:
 CD "%Temp%" CD "%Temp%"
  
-START "MariaDB Server" /MIN /D "%Temp%" "%ProgramFiles%\MariaDB 12.3\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini"+START "MariaDB Server" /MIN /D "%Temp%" "%ProgramFiles%\MariaDB 13.0\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini"
 "%SystemRoot%\System32\timeout.exe" /T "2" /NOBREAK "%SystemRoot%\System32\timeout.exe" /T "2" /NOBREAK
  
Line 364: Line 355:
 "%ProgramFiles%\Git\bin\git.exe" -C "%UserProfile%\Projects\TrinityCore-335\src" pull origin "3.3.5" --rebase "%ProgramFiles%\Git\bin\git.exe" -C "%UserProfile%\Projects\TrinityCore-335\src" pull origin "3.3.5" --rebase
  
-"%ProgramFiles%\CMake\bin\cmake.exe" -S "%UserProfile%\Projects\TrinityCore-335\src" -B "%UserProfile%\Projects\TrinityCore-335\build" -G "Visual Studio 17 2022" --fresh -Wno-error="author" -DBOOST_ROOT="%SystemDrive%/local/boost_1_91_0" -DMYSQL_INCLUDE_DIR="%ProgramFiles%\MariaDB 12.3\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 12.3\lib\libmariadb.lib" -DNOJEM="1" -DSCRIPTS="static" -DUSE_COREPCH="0" -DUSE_SCRIPTPCH="0" -DCMAKE_CXX_FLAGS="/EHs /arch:AVX2 /favor:INTEL64 /Gz /Oy /GS- /guard:cf- /W0" -DWITHOUT_METRICS="1" -DTOOLS="0"+"%ProgramFiles%\CMake\bin\cmake.exe" -S "%UserProfile%\Projects\TrinityCore-335\src" -B "%UserProfile%\Projects\TrinityCore-335\build" -G "Visual Studio 18 2026" --fresh -Wno-error="author" -DBOOST_ROOT="%SystemDrive%/local/boost_1_91_0" -DMYSQL_INCLUDE_DIR="%ProgramFiles%\MariaDB 13.0\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 13.0\lib\libmariadb.lib" -DNOJEM="1" -DSCRIPTS="static" -DUSE_COREPCH="0" -DUSE_SCRIPTPCH="0" -DCMAKE_CXX_FLAGS="/EHs /arch:AVX2 /favor:INTEL64 /Gz /Oy /GS- /guard:cf- /W0" -DWITHOUT_METRICS="1" -DTOOLS="0"
  
-"%ProgramFiles%\Microsoft Visual Studio\2022\Community\MSBuild\Current\Bin\amd64\MSBuild.exe" "%UserProfile%\Projects\TrinityCore-335\build\ALL_BUILD.vcxproj" -target:"Build" -property:"Configuration=Release" -maxCpuCount -nodeReuse:"False" -terminalLogger:"off"+"%ProgramFiles%\Microsoft Visual Studio\18\Community\MSBuild\Current\Bin\amd64\MSBuild.exe" "%UserProfile%\Projects\TrinityCore-335\build\ALL_BUILD.vcxproj" -target:"Build" -property:"Configuration=Release" -maxCpuCount -nodeReuse:"False" -terminalLogger:"off"
  
 "%SystemRoot%\System32\timeout.exe" /T "1" "%SystemRoot%\System32\timeout.exe" /T "1"
Line 390: Line 381:
 "%ProgramFiles%\Git\bin\git.exe" -C "%UserProfile%\Projects\TrinityCore-335\src" pull origin "3.3.5" --rebase "%ProgramFiles%\Git\bin\git.exe" -C "%UserProfile%\Projects\TrinityCore-335\src" pull origin "3.3.5" --rebase
  
-"%ProgramFiles(x86)%\Microsoft Visual Studio\Installer\setup.exe" update --channelId "VisualStudio.17.Release" --channelURI "https://aka.ms/vs/17/release/channel" --productId "Microsoft.VisualStudio.Product.Community" --nocache --norestart --quiet+"%ProgramFiles(x86)%\Microsoft Visual Studio\Installer\setup.exe" update --channelId "VisualStudio.18.Stable" --channelURI "https://aka.ms/vs/stable/channel" --productId "Microsoft.VisualStudio.Product.Community" --nocache --norestart --quiet
  
-"%ProgramFiles%\CMake\bin\cmake.exe" -S "%UserProfile%\Projects\TrinityCore-335\src" -B "%UserProfile%\Projects\TrinityCore-335\build" -G "Visual Studio 17 2022" --fresh -Wno-error="author" -DBOOST_ROOT="%SystemDrive%/local/boost_1_91_0" -DMYSQL_INCLUDE_DIR="%ProgramFiles%\MariaDB 12.3\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 12.3\lib\libmariadb.lib" -DNOJEM="1" -DSCRIPTS="static" -DUSE_COREPCH="0" -DUSE_SCRIPTPCH="0" -DCMAKE_CXX_FLAGS="/EHs /arch:AVX2 /favor:INTEL64 /Gz /Oy /GS- /guard:cf- /W0" -DWITHOUT_METRICS="1" -DTOOLS="0"+"%ProgramFiles%\CMake\bin\cmake.exe" -S "%UserProfile%\Projects\TrinityCore-335\src" -B "%UserProfile%\Projects\TrinityCore-335\build" -G "Visual Studio 18 2026" --fresh -Wno-error="author" -DBOOST_ROOT="%SystemDrive%/local/boost_1_91_0" -DMYSQL_INCLUDE_DIR="%ProgramFiles%\MariaDB 13.0\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 13.0\lib\libmariadb.lib" -DNOJEM="1" -DSCRIPTS="static" -DUSE_COREPCH="0" -DUSE_SCRIPTPCH="0" -DCMAKE_CXX_FLAGS="/EHs /arch:AVX2 /favor:INTEL64 /Gz /Oy /GS- /guard:cf- /W0" -DWITHOUT_METRICS="1" -DTOOLS="0"
  
-"%ProgramFiles%\Microsoft Visual Studio\2022\Community\MSBuild\Current\Bin\amd64\MSBuild.exe" "%UserProfile%\Projects\TrinityCore-335\build\ALL_BUILD.vcxproj" -target:"Rebuild" -property:"Configuration=Release" -maxCpuCount -nodeReuse:"False" -terminalLogger:"off"+"%ProgramFiles%\Microsoft Visual Studio\18\Community\MSBuild\Current\Bin\amd64\MSBuild.exe" "%UserProfile%\Projects\TrinityCore-335\build\ALL_BUILD.vcxproj" -target:"Rebuild" -property:"Configuration=Release" -maxCpuCount -nodeReuse:"False" -terminalLogger:"off"
  
 "%SystemRoot%\System32\timeout.exe" /T "1" "%SystemRoot%\System32\timeout.exe" /T "1"
Line 413: Line 404:
 CD "%Temp%" CD "%Temp%"
  
-START "MariaDB Server" /MIN /D "%Temp%" "%ProgramFiles%\MariaDB 12.3\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock"+START "MariaDB Server" /MIN /D "%Temp%" "%ProgramFiles%\MariaDB 13.0\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock"
 "%SystemRoot%\System32\timeout.exe" /T "2" /NOBREAK "%SystemRoot%\System32\timeout.exe" /T "2" /NOBREAK
  
-"%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --opt --single-transaction -r "%UserProfile%\Downloads\%RANDOM%-localhost-authserver.sql" "authserver" +"%ProgramFiles%\MariaDB 13.0\bin\mariadb-dump.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --opt --single-transaction -r "%UserProfile%\Downloads\%RANDOM%-localhost-authserver.sql" "authserver" 
-"%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --opt --single-transaction -r "%UserProfile%\Downloads\%RANDOM%-localhost-characters.sql" "characters"+"%ProgramFiles%\MariaDB 13.0\bin\mariadb-dump.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --opt --single-transaction -r "%UserProfile%\Downloads\%RANDOM%-localhost-characters.sql" "characters"
  
-"%ProgramFiles%\MariaDB 12.3\bin\mariadb-admin.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" "shutdown"+"%ProgramFiles%\MariaDB 13.0\bin\mariadb-admin.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" "shutdown"
  
 "%SystemRoot%\System32\msg.exe" %USERNAME% /TIME:"2" "WoW 3.3.5 Databases Backed-up Successfully to Downloads" "%SystemRoot%\System32\msg.exe" %USERNAME% /TIME:"2" "WoW 3.3.5 Databases Backed-up Successfully to Downloads"
Line 437: Line 428:
 CD "%Temp%" CD "%Temp%"
  
-START "MariaDB Server" /MIN /D "%Temp%" "%ProgramFiles%\MariaDB 12.3\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock"+START "MariaDB Server" /MIN /D "%Temp%" "%ProgramFiles%\MariaDB 13.0\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock"
 "%SystemRoot%\System32\timeout.exe" /T "2" /NOBREAK "%SystemRoot%\System32\timeout.exe" /T "2" /NOBREAK
  
-"%ProgramFiles%\MariaDB 12.3\bin\mariadb-check.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --optimize --all-databases --force --extended --auto-repair+"%ProgramFiles%\MariaDB 13.0\bin\mariadb-check.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --optimize --all-databases --force --extended --auto-repair
  
-"%ProgramFiles%\MariaDB 12.3\bin\mariadb-admin.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" "shutdown"+"%ProgramFiles%\MariaDB 13.0\bin\mariadb-admin.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" "shutdown"
  
 "%SystemRoot%\System32\msg.exe" %USERNAME% /TIME:"2" "WoW 3.3.5 Database Maintenance Complete" "%SystemRoot%\System32\msg.exe" %USERNAME% /TIME:"2" "WoW 3.3.5 Database Maintenance Complete"
Line 509: Line 500:
   * Ctrl + C to exit   * Ctrl + C to exit
  
-  "%ProgramFiles%\MariaDB 12.3\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini"+  "%ProgramFiles%\MariaDB 13.0\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini"
  
   CD "%UserProfile%\Projects\TrinityCore-335\build\bin\Release" && "authserver.exe" --config-dir "%UserProfile%\Projects\TrinityCore-335\conf\authserver"   CD "%UserProfile%\Projects\TrinityCore-335\build\bin\Release" && "authserver.exe" --config-dir "%UserProfile%\Projects\TrinityCore-335\conf\authserver"
Line 551: Line 542:
 ===== Backup ===== ===== Backup =====
  
-  "%ProgramFiles%\MariaDB 12.3\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock"+  "%ProgramFiles%\MariaDB 13.0\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock"
  
-  "%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --opt --single-transaction -r "%UserProfile%\Downloads\localhost-authserver.sql" "authserver"+  "%ProgramFiles%\MariaDB 13.0\bin\mariadb-dump.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --opt --single-transaction -r "%UserProfile%\Downloads\localhost-authserver.sql" "authserver"
  
-  "%ProgramFiles%\MariaDB 12.3\bin\mariadb-dump.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --opt --single-transaction -r "%UserProfile%\Downloads\localhost-characters.sql" "characters"+  "%ProgramFiles%\MariaDB 13.0\bin\mariadb-dump.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --opt --single-transaction -r "%UserProfile%\Downloads\localhost-characters.sql" "characters"
  
 ===== Restore ===== ===== Restore =====
Line 561: Line 552:
   * [[#databases|Initial set-up]]   * [[#databases|Initial set-up]]
  
-  "%ProgramFiles%\MariaDB 12.3\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock"+  "%ProgramFiles%\MariaDB 13.0\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock"
  
 ==== authserver ==== ==== authserver ====
  
-  "%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --execute="CREATE DATABASE authserver"+  "%ProgramFiles%\MariaDB 13.0\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --execute="CREATE DATABASE authserver"
  
-  MOVE /Y "%UserProfile%\Downloads\"*"-localhost-authserver.sql" "%UserProfile%\Downloads\localhost-authserver.sql" && "%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" "authserver" < "%UserProfile%\Downloads\localhost-authserver.sql"+  MOVE /Y "%UserProfile%\Downloads\"*"-localhost-authserver.sql" "%UserProfile%\Downloads\localhost-authserver.sql" && "%ProgramFiles%\MariaDB 13.0\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" "authserver" < "%UserProfile%\Downloads\localhost-authserver.sql"
  
 ==== characters ==== ==== characters ====
  
-  "%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --execute="CREATE DATABASE characters"+  "%ProgramFiles%\MariaDB 13.0\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --execute="CREATE DATABASE characters"
  
-  MOVE /Y "%UserProfile%\Downloads\"*"-localhost-characters.sql" "%UserProfile%\Downloads\localhost-characters.sql" && "%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" "characters" < "%UserProfile%\Downloads\localhost-characters.sql"+  MOVE /Y "%UserProfile%\Downloads\"*"-localhost-characters.sql" "%UserProfile%\Downloads\localhost-characters.sql" && "%ProgramFiles%\MariaDB 13.0\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" "characters" < "%UserProfile%\Downloads\localhost-characters.sql"
  
 ====== TODOs ====== ====== TODOs ======
  
-  "%ProgramFiles%\MariaDB 12.3\bin\mariadb-admin.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" variables+  "%ProgramFiles%\MariaDB 13.0\bin\mariadb-admin.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" variables
  
-  "%ProgramFiles%\MariaDB 12.3\bin\mariadb-admin.exe" -u "root" --socket="MySQL" variables+  "%ProgramFiles%\MariaDB 13.0\bin\mariadb-admin.exe" -u "root" --socket="MySQL" variables
  
-  "%ProgramFiles%\MariaDB 12.3\bin\mariadb-admin.exe" -u "root" --socket="MySQL" variables  | FIND "socket"+  "%ProgramFiles%\MariaDB 13.0\bin\mariadb-admin.exe" -u "root" --socket="MySQL" variables  | FIND "socket"
  
   character deleted old 1   character deleted old 1
Line 589: Line 580:
 **** ****
  
-  "%ProgramFiles(x86)%\Microsoft Visual Studio\Installer\setup.exe" update --channelId "VisualStudio.17.Release" --channelURI "https://aka.ms/vs/17/release/channel" --productId "Microsoft.VisualStudio.Product.Community" --nocache --norestart --quiet+  "%ProgramFiles(x86)%\Microsoft Visual Studio\Installer\setup.exe" update --channelId "VisualStudio.18.Stable" --channelURI "https://aka.ms/vs/stable/channel" --productId "Microsoft.VisualStudio.Product.Community" --nocache --norestart --quiet
  
 ===== DB Maintenance ===== ===== DB Maintenance =====
Line 595: Line 586:
 **** ****
  
-  "%ProgramFiles%\MariaDB 12.3\bin\mariadb-check.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --optimize --all-databases --force --extended --auto-repair+  "%ProgramFiles%\MariaDB 13.0\bin\mariadb-check.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --optimize --all-databases --force --extended --auto-repair
  
 ===== DB Reset ===== ===== DB Reset =====
Line 603: Line 594:
   * Import [[#world_database|World DB]]   * Import [[#world_database|World DB]]
  
-  "%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --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;"+  "%ProgramFiles%\MariaDB 13.0\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --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;"
  
/srv/www/wiki/data/attic/servers/windows/games/trinitycore_3.3.5_localhost.1780115143.txt.gz · Last modified: by Sean Rhone

Except where otherwise noted, content on this wiki is licensed under the following license: CC0 1.0 Universal
CC0 1.0 Universal Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki