====== Information ======

  * MariaDB Server

====== MariaDB ======

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

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

===== Install Options =====

  * ''[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

==== TrinityCore ====

  * [[servers;windows;games;trinitycore_3.3.5_localhost|3.3.5 (localhost)]]

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

  * ''[ ]'' 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"

====== Server ======

****

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

====== Maintenance ======

****

<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