Table of Contents

Information

MariaDB

Install Options

TrinityCore

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

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

Maintenance

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

Scripts

localhost

"notepad.exe" "%UserProfile%\Downloads\DB Maintenance.bat"
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
"%UserProfile%\Downloads\DB Maintenance.bat"

Server

MKDIR "%SystemDrive%\www\scripts\mariadb"
"notepad.exe" "%SystemDrive%\www\scripts\mariadb\Maintenance.bat"
"%ProgramFiles%\MariaDB 12.0\bin\mariadb-check.exe" -u "root" -p -o -A -f -e --auto-repair

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

Desktop

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