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/11 04:00] Sean Rhoneservers:windows:mariadb [2025/08/25 10:18] (current) – mariadb-12.1.1-winx64.msi Sean Rhone
Line 2: Line 2:
  
   * MariaDB Server   * MariaDB Server
-  * [[windows:10|Windows 10 (21H2)]] ([[windows;10_ltsc_server|Server]])+ 
 +===== Prerequisites ===== 
 + 
 +  * [[windows;10|Windows 10 (21H2)]]
  
 ====== MariaDB ====== ====== MariaDB ======
Line 9: Line 12:
   * http://downloads.mariadb.org/mariadb/12.0.1/   * http://downloads.mariadb.org/mariadb/12.0.1/
   * https://downloads.mariadb.org/rest-api/mariadb/   * 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   * No Development components or Third party tools
Line 42: Line 45:
 ====== Firewall ====== ====== Firewall ======
  
-  "netsh.exe" advfirewall firewall add rule name="MariaDB Server" dir="in" action="block" profile="any" program="%ProgramFiles%\MariaDB 12.0\bin\mariadbd.exe"+  DIR "%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe"
  
-  "netsh.exe" advfirewall firewall delete rule name="MariaDB Server"+  "netsh.exe" advfirewall firewall add rule name="MariaDB Server" dir="in" action="block" profile="any" program="%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe"
  
-====== Server ======+===== Delete Rule =====
  
 **** ****
  
-  "%ProgramFiles%\MariaDB 12.0\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.0\data\my.ini"+  "netsh.exe" advfirewall firewall delete rule name="MariaDB Server"
  
 ====== Maintenance ====== ====== 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" --o -A -f -e --auto-repair</code>+  "%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.1\data\my.ini"
  
 ===== Scripts ===== ===== Scripts =====
Line 65: Line 76:
  
 <code> <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> :: End</code>
Line 80: Line 92:
  
 <code> <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> :: End</code>
/usr/local/www/wiki/data/attic/servers/windows/mariadb.1749628848.txt.gz · Last modified: by Sean Rhone