User Tools

Site Tools


servers:windows:mariadb

This is an old revision of the document!


Information

MariaDB

  • 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

  • [x] Development components
    • [x] Client C API library (shared)
  • [ ] Install as service
  • [ ] Enable networking

Server

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

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

"%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

Server

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

:: End
/srv/www/wiki/data/attic/servers/windows/mariadb.1749628558.txt.gz · Last modified: by Sean Rhone