User Tools

Site Tools


servers:windows:mariadb

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:mariadb [2025/06/05 15:43] Sean Rhoneservers:windows:mariadb [2025/06/21 16:29] (current) Sean Rhone
Line 2: Line 2:
  
   * MariaDB Server   * MariaDB Server
-  * [[windows;10_ltsc_server|Windows 10 (21H2)]] 
  
 ====== MariaDB ====== ====== MariaDB ======
  
   * https://mariadb.org/download/   * https://mariadb.org/download/
 +  * http://downloads.mariadb.org/mariadb/12.0.1/
 +  * https://downloads.mariadb.org/rest-api/mariadb/
   * Last tested: ''mariadb-12.0.1-winx64.msi''   * Last tested: ''mariadb-12.0.1-winx64.msi''
  
   * No Development components or Third party tools   * No Development components or Third party tools
   * Use UTF8 as default server's character set   * Use UTF8 as default server's character set
 +
 +===== Install Options =====
 +
 +  * ''[x]'' MariaDB Server
 +    * ''[x]'' Database instance
 +    * ''[x]'' Client Programs
 +    * ''[x]'' Backup utilities
 +  * ''[ ]'' Development components
 +    * ''[ ]'' Client C API library (shared)
 +  * ''[ ]'' Third party tools
 +    * ''[ ]'' HeidiSQL
 +
 +  * ''[x]'' Use UTF8 as default server's character set
 +
 +  * ''[x]'' Install as service
 +  * ''[x]'' Enable networking
 +
 +==== TrinityCore ====
 +
 +  * [[servers;windows;games;trinitycore_3.3.5_localhost|3.3.5 (localhost)]]
 +
 +  * ''[x]'' Development components
 +    * ''[x]'' Client C API library (shared)
 +
 +  * ''[ ]'' Install as service
 +  * ''[ ]'' Enable networking
 +
 +====== Firewall ======
 +
 +  "netsh.exe" advfirewall firewall add rule name="MariaDB Server" dir="in" action="block" profile="any" program="%ProgramFiles%\MariaDB 12.0\bin\mariadbd.exe"
 +
 +  "netsh.exe" advfirewall firewall delete rule name="MariaDB Server"
 +
 +====== Server ======
 +
 +****
 +
 +  "%ProgramFiles%\MariaDB 12.0\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.0\data\my.ini"
  
 ====== Maintenance ====== ====== Maintenance ======
Line 17: Line 56:
  
 <code>"%ProgramFiles%\MariaDB 12.0\bin\mariadb-check.exe" -u "root" -p -o -A -f -e --auto-repair</code> <code>"%ProgramFiles%\MariaDB 12.0\bin\mariadb-check.exe" -u "root" -p -o -A -f -e --auto-repair</code>
 +
 +===== Scripts =====
 +
 +==== localhost ====
 +
 +  "notepad.exe" "%UserProfile%\Downloads\DB Maintenance.bat"
 +
 +<code>
 +START "MariaDB Server" "%ProgramFiles%\MariaDB 12.0\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.0\data\my.ini"
 +
 +"%ProgramFiles%\MariaDB 12.0\bin\mariadb-check.exe" -u "root" -p -o -A -f -e --auto-repair
 +
 +:: End</code>
 +
 +  "%UserProfile%\Downloads\DB Maintenance.bat"
 +
 +==== Server ====
 +
 +  MKDIR "%SystemDrive%\www\scripts\mariadb"
 +
 +  "notepad.exe" "%SystemDrive%\www\scripts\mariadb\Maintenance.bat"
 +
 +<code>
 +"%ProgramFiles%\MariaDB 12.0\bin\mariadb-check.exe" -u "root" -p -o -A -f -e --auto-repair
 +
 +:: End</code>
 +
 +  "%SystemDrive%\www\scripts\mariadb\Maintenance.bat"
 +
 +=== Desktop ===
 +
 +  "%SystemDrive%\www\scripts\mariadb\Maintenance.bat"
 +
 +  DB Maintenance
  
/srv/www/wiki/data/attic/servers/windows/mariadb.1749152605.txt.gz · Last modified: by Sean Rhone