RoE | Wiki

User Tools

Site Tools

Trace: • lets_encrypt • trinitycore_3.3.5_localhost
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/08/06 18:39] – Sean Rhoneservers:windows:games:trinitycore_3.3.5_localhost [2026/10/19 01:45] (current) – [CMake] Sean Rhone
Line 40: Line 40:
   * https://www.boost.org/releases/latest/   * 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.5-64.exe''+  * Last tested: ''boost_1_92_0-msvc-14.5-64.exe''
  
   msvc-14.5-64   msvc-14.5-64
Line 48: Line 48:
   * 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.4.20260805-g35fa4c3-windows-x86_64.msi''+  * Last tested: ''cmake-4.5.20261018-g7319779-windows-x86_64.msi''
  
   * ''[ ]'' Add CMake to the PATH environment variable   * ''[ ]'' Add CMake to the PATH environment variable
Line 58: Line 58:
  
   * https://slproweb.com/products/Win32OpenSSL.html (:!: not Light)   * https://slproweb.com/products/Win32OpenSSL.html (:!: not Light)
-  * Last tested: ''Win64OpenSSL-4_0_1.exe''+  * Last tested: ''Win64OpenSSL-4_0_3.exe''
  
   * Copy OpenSSL DLLs to:   * Copy OpenSSL DLLs to:
Line 96: Line 96:
 ===== Initialize ===== ===== Initialize =====
  
-  "%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"+  "%ProgramFiles%\MariaDB 13.1\bin\mariadb-install-db.exe" --skip-networking --datadir="%UserProfile%\Projects\TrinityCore-335\mariadb\database" --config="%UserProfile%\Projects\TrinityCore-335\mariadb\custom.cnf"
  
 ===== Connect ===== ===== Connect =====
  
-  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"+  START "MariaDB Server" /MIN /D "%Temp%" "%ProgramFiles%\MariaDB 13.1\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\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock"+  "%ProgramFiles%\MariaDB 13.1\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock"
  
 ===== Databases ===== ===== Databases =====
Line 136: Line 136:
 ===== CMake ===== ===== CMake =====
  
-==== CXX_FLAGS Info ==== +<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_92_0" -DMYSQL_INCLUDE_DIR="%ProgramFiles%\MariaDB 13.1\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 13.1\lib\libmariadb.lib" -DNOJEM="1" -DSCRIPTS="static" -DUSE_COREPCH="0" -DUSE_SCRIPTPCH="0" -DWITHOUT_METRICS="1" -DTOOLS="1"</code>
- +
-  * [[https://learn.microsoft.com/en-us/cpp/build/reference/eh-exception-handling-model?view=msvc-170|/EHs]] +
-  * [[https://learn.microsoft.com/en-us/cpp/build/reference/arch-x64?view=msvc-170|/arch:AVX2]] +
-  * [[https://learn.microsoft.com/en-us/cpp/build/reference/favor-optimize-for-architecture-specifics?view=msvc-170|/favor:INTEL64]] +
-  * [[https://learn.microsoft.com/en-us/cpp/build/reference/gd-gr-gv-gz-calling-convention?view=msvc-170|/Gz]] +
-  * [[https://learn.microsoft.com/en-us/cpp/build/reference/oy-frame-pointer-omission?view=msvc-170|/Oy]] +
-  * [[https://learn.microsoft.com/en-us/cpp/build/reference/gs-buffer-security-check?view=msvc-170|/GS-]] +
-  * [[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 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> +
- +
-  /arch:SSE4.2+
  
 ===== Compile ===== ===== Compile =====
  
   * ~20 minutes i5-8400H ((2026/07/06: ''00:17:08.50'' 4C8T MSVC))   * ~20 minutes i5-8400H ((2026/07/06: ''00:17:08.50'' 4C8T MSVC))
-  * 30 minutes i5-6400T ((2026/07/30: ''00:29:13.36'' Clang))+  * 30 minutes i5-6400T ((2026/10/12: ''00:30:50.30'' MSVC)) ((2026/07/30: ''00:29:13.36'' Clang))
  
 <code>"%ProgramFiles%\Microsoft Visual Studio\18\Insiders\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\Insiders\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>
Line 159: Line 147:
 ===== DLLs ===== ===== DLLs =====
  
-  COPY /Y "%ProgramFiles%\MariaDB 13.0\lib\libmariadb.dll" "%UserProfile%\Projects\TrinityCore-335\build\bin\Release"+  COPY /Y "%ProgramFiles%\MariaDB 13.1\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 199: Line 187:
   * ''mmaps_generator.exe''   * ''mmaps_generator.exe''
   * :!: 30-40 minutes i5-8400H ((2026/07/06: ''36 Minutes 45 Seconds'' 4C8T)) ((2026/03/03: 32 Minutes ([[servers:windows:games:trinitycore_3.3.5_localhost?rev=1775702616|Clang]]) 4C8T))   * :!: 30-40 minutes i5-8400H ((2026/07/06: ''36 Minutes 45 Seconds'' 4C8T)) ((2026/03/03: 32 Minutes ([[servers:windows:games:trinitycore_3.3.5_localhost?rev=1775702616|Clang]]) 4C8T))
 +  * :!: ~60 minutes i5-6400T ((2026/10/13: ''58 Minutes 54 Seconds''))
 +
   * ''--threads %NUMBER_OF_PROCESSORS%''   * ''--threads %NUMBER_OF_PROCESSORS%''
  
Line 221: Line 211:
   * https://github.com/TrinityCore/TrinityCore/releases   * https://github.com/TrinityCore/TrinityCore/releases
   * Expects [[windows:10#zip|7-Zip]] and [[#databases|Initial DB set-up]]   * 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.26091_2026_09_09.7z''
  
-  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"+  START "MariaDB Server" /MIN /D "%Temp%" "%ProgramFiles%\MariaDB 13.1\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 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"+  "%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.1\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 231: Line 221:
 ===== authserver ===== ===== authserver =====
  
-  * Last commit: [[https://github.com/TrinityCore/TrinityCore/commit/440847c19346aaeb1e67297320db0eb51217f916|Apr 9, 2026]] ''440847c''+  * Last commit: [[https://github.com/TrinityCore/TrinityCore/commit/1a11363215dbacd6af82f4fd70fb2d187d851bc0|Sep 10, 2026]] ''1a11363''
   * [[https://github.com/TrinityCore/TrinityCore/commits/3.3.5/src/server/authserver/authserver.conf.dist|New commits check]]   * [[https://github.com/TrinityCore/TrinityCore/commits/3.3.5/src/server/authserver/authserver.conf.dist|New commits check]]
   * [[https://github.com/TrinityCore/TrinityCore/blob/3.3.5/src/server/authserver/authserver.conf.dist|Upstream authserver.conf.dist]] ([[https://raw.githubusercontent.com/TrinityCore/TrinityCore/3.3.5/src/server/authserver/authserver.conf.dist|raw]])   * [[https://github.com/TrinityCore/TrinityCore/blob/3.3.5/src/server/authserver/authserver.conf.dist|Upstream authserver.conf.dist]] ([[https://raw.githubusercontent.com/TrinityCore/TrinityCore/3.3.5/src/server/authserver/authserver.conf.dist|raw]])
Line 244: Line 234:
 # Connection # Connection
 BindIP = "127.0.0.1" BindIP = "127.0.0.1"
-MySQLExecutable = "C:\Program Files\MariaDB 13.0\bin\mariadb.exe"+MySQLExecutable = "C:\Program Files\MariaDB 13.1\bin\mariadb.exe"
 AllowLoggingIPAddressesInDatabase = 0 AllowLoggingIPAddressesInDatabase = 0
  
Line 258: Line 248:
 ===== worldserver ===== ===== worldserver =====
  
-  * Last commit: [[https://github.com/TrinityCore/TrinityCore/commit/440847c19346aaeb1e67297320db0eb51217f916|Apr 9, 2026]] ''440847c''+  * Last commit: [[https://github.com/TrinityCore/TrinityCore/commit/e185b2f98c42abe7805ea2c70c8cad4d60aaf781|Sep 14, 2026]] ''e185b2f''
   * [[https://github.com/TrinityCore/TrinityCore/commits/3.3.5/src/server/worldserver/worldserver.conf.dist|New commits check]]   * [[https://github.com/TrinityCore/TrinityCore/commits/3.3.5/src/server/worldserver/worldserver.conf.dist|New commits check]]
   * [[https://github.com/TrinityCore/TrinityCore/blob/3.3.5/src/server/worldserver/worldserver.conf.dist|Upstream worldserver.conf.dist]] ([[https://raw.githubusercontent.com/TrinityCore/TrinityCore/3.3.5/src/server/worldserver/worldserver.conf.dist|raw]])   * [[https://github.com/TrinityCore/TrinityCore/blob/3.3.5/src/server/worldserver/worldserver.conf.dist|Upstream worldserver.conf.dist]] ([[https://raw.githubusercontent.com/TrinityCore/TrinityCore/3.3.5/src/server/worldserver/worldserver.conf.dist|raw]])
Line 271: Line 261:
 # Connection # Connection
 BindIP = "127.0.0.1" BindIP = "127.0.0.1"
-MySQLExecutable = "C:\Program Files\MariaDB 13.0\bin\mariadb.exe"+MySQLExecutable = "C:\Program Files\MariaDB 13.1\bin\mariadb.exe"
 AllowLoggingIPAddressesInDatabase = 0 AllowLoggingIPAddressesInDatabase = 0
  
Line 334: Line 324:
 CD "%Temp%" CD "%Temp%"
  
-START "MariaDB Server" /MIN /D "%Temp%" "%ProgramFiles%\MariaDB 13.0\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini"+START "MariaDB Server" /MIN /D "%Temp%" "%ProgramFiles%\MariaDB 13.1\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 357: Line 347:
 "%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 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%\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_92_0" -DMYSQL_INCLUDE_DIR="%ProgramFiles%\MariaDB 13.1\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 13.1\lib\libmariadb.lib" -DNOJEM="1" -DSCRIPTS="static" -DUSE_COREPCH="0" -DUSE_SCRIPTPCH="0" -DWITHOUT_METRICS="1" -DTOOLS="0"
  
 "%ProgramFiles%\Microsoft Visual Studio\18\Insiders\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\Insiders\MSBuild\Current\Bin\amd64\MSBuild.exe" "%UserProfile%\Projects\TrinityCore-335\build\ALL_BUILD.vcxproj" -target:"Build" -property:"Configuration=Release" -maxCpuCount -nodeReuse:"False" -terminalLogger:"off"
Line 385: Line 375:
 "%ProgramFiles(x86)%\Microsoft Visual Studio\Installer\setup.exe" update --channelId "VisualStudio.18.Insiders" --channelURI "https://aka.ms/vs/insiders/channel" --productId "Microsoft.VisualStudio.Product.Community" --nocache --norestart --quiet "%ProgramFiles(x86)%\Microsoft Visual Studio\Installer\setup.exe" update --channelId "VisualStudio.18.Insiders" --channelURI "https://aka.ms/vs/insiders/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 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%\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_92_0" -DMYSQL_INCLUDE_DIR="%ProgramFiles%\MariaDB 13.1\include\mysql" -DMYSQL_LIBRARY="%ProgramFiles%\MariaDB 13.1\lib\libmariadb.lib" -DNOJEM="1" -DSCRIPTS="static" -DUSE_COREPCH="0" -DUSE_SCRIPTPCH="0" -DWITHOUT_METRICS="1" -DTOOLS="0"
  
 "%ProgramFiles%\Microsoft Visual Studio\18\Insiders\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\Insiders\MSBuild\Current\Bin\amd64\MSBuild.exe" "%UserProfile%\Projects\TrinityCore-335\build\ALL_BUILD.vcxproj" -target:"Rebuild" -property:"Configuration=Release" -maxCpuCount -nodeReuse:"False" -terminalLogger:"off"
Line 406: Line 396:
 CD "%Temp%" CD "%Temp%"
  
-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"+START "MariaDB Server" /MIN /D "%Temp%" "%ProgramFiles%\MariaDB 13.1\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 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 13.1\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-characters.sql" "characters"+"%ProgramFiles%\MariaDB 13.1\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-admin.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" "shutdown"+"%ProgramFiles%\MariaDB 13.1\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 430: Line 420:
 CD "%Temp%" CD "%Temp%"
  
-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"+START "MariaDB Server" /MIN /D "%Temp%" "%ProgramFiles%\MariaDB 13.1\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 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 13.1\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-admin.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" "shutdown"+"%ProgramFiles%\MariaDB 13.1\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 500: Line 490:
   * Ctrl + C to exit   * Ctrl + C to exit
  
-  "%ProgramFiles%\MariaDB 13.0\bin\mariadbd.exe" --defaults-file="%UserProfile%\Projects\TrinityCore-335\mariadb\database\my.ini"+  "%ProgramFiles%\MariaDB 13.1\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 542: Line 532:
 ===== Backup ===== ===== Backup =====
  
-  "%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 13.1\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\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.1\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-characters.sql" "characters"+  "%ProgramFiles%\MariaDB 13.1\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 552: Line 542:
   * [[#databases|Initial set-up]]   * [[#databases|Initial set-up]]
  
-  "%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 13.1\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 13.0\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --execute="CREATE DATABASE authserver"+  "%ProgramFiles%\MariaDB 13.1\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 13.0\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.1\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" "authserver" < "%UserProfile%\Downloads\localhost-authserver.sql"
  
 ==== characters ==== ==== characters ====
  
-  "%ProgramFiles%\MariaDB 13.0\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --execute="CREATE DATABASE characters"+  "%ProgramFiles%\MariaDB 13.1\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 13.0\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.1\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" "characters" < "%UserProfile%\Downloads\localhost-characters.sql"
  
 ====== TODOs ====== ====== TODOs ======
  
-  "%ProgramFiles%\MariaDB 13.0\bin\mariadb-admin.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" variables+  "%ProgramFiles%\MariaDB 13.1\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="MySQL" variables+  "%ProgramFiles%\MariaDB 13.1\bin\mariadb-admin.exe" -u "root" --socket="MySQL" variables
  
-  "%ProgramFiles%\MariaDB 13.0\bin\mariadb-admin.exe" -u "root" --socket="MySQL" variables  | FIND "socket"+  "%ProgramFiles%\MariaDB 13.1\bin\mariadb-admin.exe" -u "root" --socket="MySQL" variables  | FIND "socket"
  
   character deleted old 1   character deleted old 1
Line 582: Line 572:
 ===== DB Maintenance ===== ===== DB Maintenance =====
  
-  "%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 13.1\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 590: Line 580:
   * Import [[#world_database|World DB]]   * Import [[#world_database|World DB]]
  
-  "%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;"+  "%ProgramFiles%\MariaDB 13.1\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;"
  
 ==== auth/character ==== ==== auth/character ====
  
-  "%ProgramFiles%\MariaDB 13.0\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --execute="DROP DATABASE authserver;DROP DATABASE characters;CREATE DATABASE authserver;CREATE DATABASE characters;GRANT ALL PRIVILEGES ON authserver.* to 'authserver'@'localhost';GRANT ALL PRIVILEGES ON characters.* to 'characters'@'localhost';FLUSH PRIVILEGES;"+  "%ProgramFiles%\MariaDB 13.1\bin\mariadb.exe" -u "root" --socket="%UserProfile%\Projects\TrinityCore-335\mariadb\mariadb.sock" --execute="DROP DATABASE authserver;DROP DATABASE characters;CREATE DATABASE authserver;CREATE DATABASE characters;GRANT ALL PRIVILEGES ON authserver.* to 'authserver'@'localhost';GRANT ALL PRIVILEGES ON characters.* to 'characters'@'localhost';FLUSH PRIVILEGES;"
  
/srv/www/wiki/data/attic/servers/windows/games/trinitycore_3.3.5_localhost.1786055978.txt.gz · Last modified: by Sean Rhone