批处理脚本一键安装MariaDb数据库的操作

脚本代码如下
附件包含，这几个需求额外下在安装包
BiopseeSrcConfig.reg
mariadb-11.2.2-winx64.msi
mariadb-connector-odbc-3.1.20-win64.msi
ODBCConfig.reg

@echo off
%1 mshta vbscript:CreateObject(“Shell.Application”).ShellExecute(“cmd.exe”,“/c %~s0 ::”,“”,“runas”,1)(window.close)&&exit
cd /d “%~dp0”

@echo Script version V1.0.0.0

@echo install ODBC now. please wait…

msiexec /i mariadb-connector-odbc-3.1.20-win64.msi /qn
regedit.exe/s ODBCConfig.reg
regedit.exe/s BiopseeSrcConfig.reg
@echo install ODBC Finished

cd /d “%~dp0”
@echo install MariaDB now. please wait…
msiexec /i mariadb-11.2.2-winx64.msi SERVICENAME=AAA_MariaDBServer DATADIR=D:\sqldata\data MYSQLSERVER=127.0.0.1 PORT=3306 PASSWORD=Biopsee@123# /qn
cd C:\Program Files\MariaDB 11.2
C:
mkdir -p data
xcopy D:\sqldata\data\my.ini “C:\Program Files\MariaDB 11.2\data”
xcopy D:\sqldata\data\multi-master.info “C:\Program Files\MariaDB 11.2\data”

setx -m path “%path%;C:\Program Files\MariaDb 11.2\bin”
@echo install Finished.

pause

安装包下载目前请见其他文章
https://download.youkuaiyun.com/download/u011533780/89373677