| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| servers:windows:games:trinitycore_3.3.5_localhost [2026/05/30 01:38] – [DLLs] Sean Rhone | servers:windows:games:trinitycore_3.3.5_localhost [2026/05/30 21:33] (current) – VS2026 looks good Sean Rhone |
|---|
| ====== 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 ===== |
| * 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" |
| ===== 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 ===== |
| * 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 |
| **** | **** |
| |
| "%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 ===== |
| * [[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/30: ''00:22:47.74'' 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%\MariaDB 13.0\lib\libmariadb.dll" "%UserProfile%\Projects\TrinityCore-335\build\bin\Release" |
| |
| * 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 ====== |
| # 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 |
| |
| # 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 |
| |
| 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 |
| |
| "%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" |
| "%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" |
| 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" |
| 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" |
| * 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" |
| ===== 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 ===== |
| * [[#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 |
| **** | **** |
| |
| "%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 ===== |
| **** | **** |
| |
| "%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 ===== |
| * 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;" |
| |