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/10 12:51] Sean Rhoneservers:windows:mariadb [2025/06/21 16:29] (current) Sean Rhone
Line 2: Line 2:
  
   * MariaDB Server   * MariaDB Server
-  * [[windows:10|Windows 10 (21H2)]] ([[windows;10_ltsc_server|Server]]) 
  
 ====== MariaDB ====== ====== MariaDB ======
Line 39: Line 38:
   * ''[ ]'' Install as service   * ''[ ]'' Install as service
   * ''[ ]'' Enable networking   * ''[ ]'' Enable networking
- 
-====== Server ====== 
- 
-**** 
- 
-  "%ProgramFiles%\MariaDB 12.0\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.0\data\my.ini" 
  
 ====== Firewall ====== ====== Firewall ======
Line 51: Line 44:
  
   "netsh.exe" advfirewall firewall delete rule name="MariaDB Server"   "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 57: 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.1749574302.txt.gz · Last modified: by Sean Rhone