• MariaDB Server

• Windows 10 (21H2)

• https://mariadb.org/download/
• http://downloads.mariadb.org/mariadb/12.0.1/
• https://downloads.mariadb.org/rest-api/mariadb/
• Last tested: mariadb-12.1.1-winx64.msi

• No Development components or Third party tools
• Use UTF8 as default server's character set

• [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

• 3.3.5 (localhost)

• [x] Development components
  • [x] Client C API library (shared)

• [ ] Install as service
• [ ] Enable networking

DIR "%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe"

"netsh.exe" advfirewall firewall add rule name="MariaDB Server" dir="in" action="block" profile="any" program="%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe"

"netsh.exe" advfirewall firewall delete rule name="MariaDB Server"

"%ProgramFiles%\MariaDB 12.1\bin\mariadb-check.exe" -u "root" -p -o -A -f -e --auto-repair

"%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.1\data\my.ini"

"notepad.exe" "%UserProfile%\Downloads\DB Maintenance.bat"

START "MariaDB Server" "%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.1\data\my.ini"

TIMEOUT /T "2" /NOBREAK
"%ProgramFiles%\MariaDB 12.1\bin\mariadb-check.exe" -u "root" -p -o -A -f -e --auto-repair

:: End

"%UserProfile%\Downloads\DB Maintenance.bat"

MKDIR "%SystemDrive%\www\scripts\mariadb"

"notepad.exe" "%SystemDrive%\www\scripts\mariadb\Maintenance.bat"

"%ProgramFiles%\MariaDB 12.1\bin\mariadb-check.exe" -u "root" -p -o -A -f -e --auto-repair

:: End

"%SystemDrive%\www\scripts\mariadb\Maintenance.bat"

"%SystemDrive%\www\scripts\mariadb\Maintenance.bat"

DB Maintenance