alastori

#!/bin/bash

#Bash script to install MySQL Enterprise Monitor Agent 3.x in Enterprise Linux 7.x
#Copy the MEM Agent executable binary (mysqlmonitoragent*.bin) into the $PACKAGES_DIR and run this script as root
#You can find the binaries in http://support.oracle.com (preferable) or http://edelivery.oracle.com 

#Modify these variables as you wish
DIR_TO_INSTALL=/home/vagrant/mysql/enterprise/agent #/opt/mysql/enterprise/agent
PACKAGES_DIR=/home/vagrant/packages  #This folder already contains the Executable Binaries
MEM_SERVICE_HOST=vmmysqltools

alastori

#!/bin/bash

#Bash script to make a full backup in MySQL 5.7 using MySQL Enterprise Backup 4.x
#Backup is compressed using MEB feature and packed in a single timestamped TAR file
#MEB must be already installed
#You can find the binaries in http://support.oracle.com (preferable) or http://edelivery.oracle.com 

#Modify these variables as you wish
MEB_HOME=/opt/mysql/meb-4.0
BACKUP_DIR=/tmp/bkp-full

alastori

#!/bin/bash

#Bash script to restore a full backup in MySQL 5.7 using MySQL Enterprise Backup 4.x
#You need to privide the source of your backup (full path) as an argument
#Source can be a directory or a TAR file with the backup files created by MySQL Enterprise Backup
#MEB must be already installed
#You can find the binaries in http://support.oracle.com (preferable) or http://edelivery.oracle.com 

#Modify these variables as you wish
MEB_HOME=/opt/mysql/meb-4.0

alastori

#!/bin/bash

#Bash script to install MySQL Enterprise Monitor Service Manager 3.x in Enterprise Linux 7.x
#Copy the MEM executable binary (mysqlmonitor*.bin) into the $PACKAGES_DIR and run this script as root
#You can find the binaries in http://support.oracle.com (preferable) or http://edelivery.oracle.com 

#Modify these variables as you wish
DIR_TO_INSTALL=/opt/mysql/enterprise/monitor
PACKAGES_DIR=/home/vagrant/packages   #This folder already contains the Executable Binaries
MEM_SERVICE_PORT=18443

alastori

@ECHO OFF
REM ## Windows batch script to upload of one file passed as parameter using Windows FTP client

REM ## Modify the following variables as you wish
SET FTP_SERVER=
SET FTP_USER=
SET FTP_PASSWORD=

REM ## Test if can proceed
SET FILE_NAME=%1

alastori

@ECHO OFF
REM ## Windows batch script to upload of one file passed as parameter using WinSCP console
REM ## Download WinSCP Portable Executables from http://winscp.net/eng/download.php

REM ## Modify the following variables as you wish
SET FTP_SERVER=
SET FTP_USER=
SET FTP_PASSWORD=
SET WINSCP_EXEC=winscp577\WinSCP.com

alastori

@ECHO OFF
REM ## Windows batch script to export SQL Server tables in CSV files splitted by the limit specified 

REM ## Modify the following variables as you wish
SET DATABASE_NAME=
SET TABLE_NAME=
SET FILE_LIMIT=1000

REM ## Creates destination dir and set variable COUNT_ROWS with total number of rows in the table
MD to-zip

alastori

#!/bin/bash

#Bash script to provision MySQL 5.7 Commercial via local RPMs in Enterprise Linux 7.x
#Copy the ZIP file with mysql* RPMs into the $PACKAGES_DIR and run this script as root
#You can find the commercial binaries in http://support.oracle.com (preferable) or http://edelivery.oracle.com 

#Modify these variables as you wish
DIR_TO_UNPACK=/tmp/packages
PACKAGES_DIR=/home/vagrant/packages  #This folder already contains RPMs
MYSQL_PWD="Root#123"

alastori

#!/bin/bash

#Bash script to provision Unzip via local RPMs in Enterprise Linux 7.x
#Copy the unzip*.rpm file into the $PACKAGES_DIR and run this script as root
#You can find the binaries at https://rpmfind.net/linux/RPM/centos

#Modify these variables as you wish
PACKAGES_DIR=/home/vagrant/packages  #This folder already contains RPMs

set -e    # stop script execution on any error

alastori

#!/bin/bash

#Bash script to provision MySQL 5.7 Commercial via local RPMs in Enterprise Linux 7.x
#Copy the TAR with mysql* RPMs into the $PACKAGES_DIR and run this script as root
#You can find the commercial binaries in http://support.oracle.com (preferable) or http://edelivery.oracle.com 

#Modify these variables as you wish
DIR_TO_UNPACK=/tmp/packages
PACKAGES_DIR=/home/vagrant/packages  #This folder already contains RPMs
MYSQL_PWD="Root#123"