cd E:\Elastic\elasticsearch-7.16.3\bin
.\elasticsearch-service.bat install



# ---------------------------------- Cluster -----------------------------------
#
# Use a descriptive name for your cluster:
#
cluster.name: dscribe-x
# Reset mininum amount of available disk space on ES drive from 95% to 98%
cluster.routing.allocation.disk.threshold_enabled: false
cluster.routing.allocation.disk.watermark.flood_stage: 98%
#
# ------------------------------------ Node ------------------------------------
#
# Use a descriptive name for the node:
#
node.name: node-1
node.data: true
node.ingest: true
node.master: true
xpack.security.enabled: true
#
# ----------------------------------- Paths ------------------------------------
#
# Path to directory where to store the data (separate multiple locations by comma):
#
path.repo: C:\ElasticSearch\backups



cd E:\Elastic\elasticsearch-7.16.3\bin
.\elasticsearch-setup-passwords interactive




E:\Elastic\elasticsearch-7.16.3\bin\elasticsearch-service.bat manager




early-plugin-load=keyring_file.dll 
keyring_file_data=C:\ProgramData\MySQL\MySQL Server 8.0\keyring
# bind-address=127.0.0.1



md "D:\ProgramData\MySQL\MySQL Server 8.0"
xcopy "C:\ProgramData\MySQL\MySQL Server 8.0\Data" "D:\ProgramData\MySQL\MySQL Server 8.0\Data" /E /C /I /H /K /O




xcopy "C:\ProgramData\MySQL\MySQL Server 8.0\keyring" "D:\ProgramData\MySQL\MySQL Server 8.0" /E /C /I /H /K /O
ren "C:\ProgramData\MySQL\MySQL Server 8.0\Data" "C:\ProgramData\MySQL\MySQL Server 8.0\Data_Original"
ren "C:\ProgramData\MySQL\MySQL Server 8.0\keyring" "C:\ProgramData\MySQL\MySQL Server 8.0\keyring_original" 



datadir="D:/ProgramData/MySQL/MySQL Server 8.0/Data"



keyring_file_data=D:\ProgramData\MySQL\MySQL Server 8.0\keyring



ALTER TABLE dscribex.case_events encryption='Y'; 
ALTER TABLE dscribex.case_event_values encryption='Y'; 
ALTER TABLE dscribex.ebridge_messages encryption='Y';



SELECT * 
FROM information_schema.tables 
WHERE create_options LIKE "%ENCRYPTION%";



USE dscribex;
ALTER TABLE emails MODIFY MessageId varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;