Differences

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

--- servers:windows:mariadb [2025/06/11 03:55] – Sean Rhone
+++ servers:windows:mariadb [2025/08/25 10:18] (current) – mariadb-12.1.1-winx64.msi Sean Rhone
@@ Line 2: / Line 2: @@
   * MariaDB Server
-  * [[windows:10|Windows 10 (21H2)]] ([[windows;10_ltsc_server|Server]])
+===== Prerequisites =====
+  * [[windows;10|Windows 10 (21H2)]]
 ====== MariaDB ======
@@ Line 9: / Line 12: @@
   * 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.1.1-winx64.msi''
   * No Development components or Third party tools
@@ Line 40: / Line 43: @@
   * ''[ ]'' Enable networking
-====== Server ======
+====== Firewall ======
-****
+  DIR "%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe"
-  "%ProgramFiles%\MariaDB 12.0\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.0\data\my.ini"
+  "netsh.exe" advfirewall firewall add rule name="MariaDB Server" dir="in" action="block" profile="any" program="%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe"
-====== Firewall ======
+===== Delete Rule =====
-  "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"
 ====== Maintenance ======
+===== One-shot =====
+****
+  "%ProgramFiles%\MariaDB 12.1\bin\mariadb-check.exe" -u "root" -p -o -A -f -e --auto-repair
+==== Server Start ====
 ****
-<code>"%ProgramFiles%\MariaDB 12.0\bin\mariadb-check.exe" -u "root" -p -o -A -f -e --auto-repair</code>
+  "%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.1\data\my.ini"
 ===== Scripts =====
@@ Line 65: / Line 76: @@
 <code>
-START "MariaDB Server" "%ProgramFiles%\MariaDB 12.0\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.0\data\my.ini"
+START "MariaDB Server" "%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.1\data\my.ini"
-"%ProgramFiles%\MariaDB 12.0\bin\mariadb-check.exe" -u "root" -p -o -A -f -e --auto-repair
+TIMEOUT /T "2" /NOBREAK
+"%ProgramFiles%\MariaDB 12.1\bin\mariadb-check.exe" -u "root" -p -o -A -f -e --auto-repair
 :: End</code>
+  "%UserProfile%\Downloads\DB Maintenance.bat"
 ==== Server ====
-  "notepad.exe" "%UserProfile%\Desktop\MariaDB Maintenance.bat"
+  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
+"%ProgramFiles%\MariaDB 12.1\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