Differences

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

--- servers:windows:mariadb [2025/06/05 14:58] – Sean Rhone
+++ servers:windows:mariadb [2025/06/21 16:29] (current) – Sean Rhone
@@ Line 1: / Line 1: @@
-  * [[windows;11_ltsc_server|Windows 11 (24H2)]]
+====== Information ======
-<code>"%ProgramFiles%\MariaDB 12.0\bin\mariadb-check.exe" -u "root" -p -o -A -f -e --auto-repair</code>
+  * MariaDB Server
-====== Update ======
+====== MariaDB ======
+  * 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''
+  * No Development components or Third party tools
+  * 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 ======
 ****
-  sc delete "MariaDB"
+  "%ProgramFiles%\MariaDB 12.0\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.0\data\my.ini"
+====== Maintenance ======
+****
+<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