mysqldump_backup_restore.tar

mysql_backup_restoreAll.sh0000777000000000000000000000225014614723235013203 0ustar  #!/bin/bash

# Usage: ./mysql_backup_restoreAll.sh
# mysqlump file has format: db_name.hostname.domain.DD-MM-YYYY_HHMM


# filedir="USER INPUT"
read -p "Now enter the directory where all the backupfiles resides: " filedir
# MySQL Router instance
# mysqlrouter="USER INPUT"
read -p "Now provide the MySQL Router hostname to be used:  " mysqlrouter
echo 
echo "You have entered: $filedir & $mysqlrouter:"
echo 
read -p "Continue? (Y/N): " confirm && [[ $confirm == [yY] || $confirm == [yY][eE][sS] ]] || exit 1


#BACKUPFILE=`ls $filedir| grep 00 | grep 2024_ | grep -v mysql `
#DBNAME=echo $BACKUPFILE |  cut -d . -f 1

cd $filedir

for i in `ls | grep -v mysql | grep 00 | grep 2024_ | cut -d . -f 1`; do echo "select \"""$i"\""; drop database $i; create database $i; use $i; source "`ls $i*`"; select count(table_name) from information_schema.tables where table_schema = '$i';" > cre_db_$i.sql ; echo "mysqlsh icadmin@$mysqlrouter --log-file=cre_db_$i.log --sqlc -e \"source cre_db_$i.sql;\""; echo "grep -i 'create table' `ls $i*`  | wc -l"; done > restoreAll.sh


chmod 744 $filedir/restoreAll.sh
echo 
echo "Now run 'cd $filedir' and execute './restoreAll.sh > restoreAll.sh.log '"
echo 
mysql_backup_restoredb.sh0000777000000000000000000000230114614723063013054 0ustar  #!/bin/bash

# Usage: ./mysql_backup_restoredb.sh schema_name.hostname.domain.DD-MM-YYYY_HHMM > restoredb.sh

#DIR=/mnt/backup/db-backup
#BACKUPFILE=$1
#DBNAME=echo $BACKUPFILE |  cut -d . -f 1

# BACKUPFILE="USER INPUT"
read -p "Enter the BACKUPFILE being used:                   " BACKUPFILE
# filedir="USER INPUT"
read -p "Now enter the directory where $BACKUPFILE resides: " filedir
# MySQL Router instance
# mysqlrouter="USER INPUT"
read -p "Now provide the MySQL Router hostname to be used:  " mysqlrouter
echo 
echo "You have entered: $BACKUPFILE $filedir & $mysqlrouter:"
echo 
read -p "Continue? (Y/N): " confirm && [[ $confirm == [yY] || $confirm == [yY][eE][sS] ]] || exit 1


cd $filedir
for i in `echo $BACKUPFILE | cut -d . -f 1`; do echo "select \"""$i"\""; drop database $i; create database $i; use $i; source "`ls $BACKUPFILE`"; select count(table_name) from information_schema.tables where table_schema = '$i';" > restore_cre_db_$i.sql ; echo "mysqlsh icadmin@$mysqlrouter --log-file=restore_cre_db_$i.log --sqlc -e \"source restore_cre_db_$i.sql;\""; echo "grep -i 'create table' `ls $BACKUPFILE`  | wc -l"; done > restoredb.sh


echo 
echo "Now run 'cd $filedir' and execute 'restoredb.sh'"
echo 
mysql_backup_restoredb_Pre2Pro.sh0000777000000000000000000000267614614723176014451 0ustar  #!/bin/bash

# Usage: ./mysql_backup_restoredb_Pre2Pro.sh
# mysqlump file has format: db_name.hostname.domain.DD-MM-YYYY_HHMM

# BACKUPFILE="USER INPUT"
read -p "Enter the BACKUPFILE being used:                   " BACKUPFILE
# filedir="USER INPUT"
read -p "Now enter the directory where $BACKUPFILE resides: " filedir
# MySQL Router instance
# mysqlrouter="USER INPUT"
read -p "Now provide the MySQL Router hostname to be used:  " mysqlrouter
# New DB name
# NEWDBNAME="USER INPUT"
read -p "Enter the target / new database schema name:       " NEWDBNAME
echo 
echo "You have entered: "
echo "                  "$BACKUPFILE
echo "                  "$filedir
echo "                  "$mysqlrouter
echo "                  "$NEWDBNAME
echo 
read -p "Continue? (Y/N): " confirm && [[ $confirm == [yY] || $confirm == [yY][eE][sS] ]] || exit 1


cd $filedir
for i in `echo $BACKUPFILE | cut -d . -f 1`; do echo "select \"""$i"\""; drop database $NEWDBNAME; create database $NEWDBNAME; use $NEWDBNAME; source "`ls $BACKUPFILE`"; select count(table_name) from information_schema.tables where table_schema = '$i' or table_schema = '$NEWDBNAME';" > restore_cre_db_$NEWDBNAME.sql ; echo "mysqlsh icadmin@$mysqlrouter --log-file=restore_cre_db_$NEWDBNAME.log --sqlc -e \"source restore_cre_db_$NEWDBNAME.sql;\""; echo "grep -i 'create table' `ls $BACKUPFILE`  | wc -l"; done > restoredb_$NEWDBNAME.sh


echo 
echo "Now run 'cd $filedir' and execute 'restoredb_$NEWDBNAME.sh'"
echo