Prerequisites
MariaDB
Install Options
[x]
Install as service
[x]
Enable networking
TrinityCore
[ ]
Install as service
[ ]
Enable networking
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"
Maintenance
One-shot
"%ProgramFiles%\MariaDB 12.0\bin\mariadb-check.exe" -u "root" -p -o -A -f -e --auto-repair
"%ProgramFiles%\MariaDB 12.0\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.0\data\my.ini"
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"
TIMEOUT /T "2" /NOBREAK
"%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