Update Script Backup Mysql dan Mssql

 Update Script Backup Mysql dan Mssql

1. Update Script backup mysql

root@gsmart:~# cat /root/exec_backup_full_logistic.sh;

#!/bin/bash
timestamp=`date +"%F-%H%M"`;
echo "backup full at "$timestamp >> ~/backup.log;
echo "mysqldump -h localhost -u root db_logistic > backup_db_logistic_"$timestamp > backup_full_logistic.sh;
echo "tar -czf backup_db_logistic_"$timestamp".tar.gz backup_db_logistic_"$timestamp >> backup_full_logistic.sh;
echo "rm backup_db_logistic_"$timestamp  >> backup_full_logistic.sh;

#old method using sshfs
#echo "mv backup_db_logistic_"$timestamp".tar.gz /zbackup/mysql/gsmart/db_logistic/" >> backup_full_logistic.sh;

#new method using rsync
echo "rsync -avz --bwlimit=8000 backup_db_logistic_"$timestamp".tar.gz sysadmin@172.16.41.15:/zbackup/mysql/gsmart/db_logistic" >> backup_full_logistic.sh;

#delete .tar.gz file
echo "rm backup_db_logistic_"$timestamp".tar.gz" >> backup_full_logistic.sh;

cmd="sh /root/backup_full_logistic.sh;";
eval $cmd;

2. Jalanin 
ssh-keygen -t rsa
<enter>
<enter>

ssh-copy-id sysadmin@172.16.41.15

3. Run script backup

----------------------------------------------------------------
2. Update script backup mssql

root@mssql-db-mrosystem:/home/mssql# cat exec_backup_full_db_mrosystem.sh

#!/bin/bash
timestamp=`date +"%F-%H%M"`;
#echo $timestamp;
echo "backup full at "$timestamp >> ~/backup.log;
echo "backup database db_ams to disk = '/home/mssql/backup_db_ams_"$timestamp"'" > backup_full_db_ams.sql;
echo "go" >> backup_full_db_ams.sql;
cmd="/opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P GMF2018#1 -i /home/mssql/backup_full_db_ams.sql;";
eval $cmd;

echo "bzip2 /home/mssql/backup_db_ams_"$timestamp"" >> send_backup.sh;
echo "rsync -avz --bwlimit=8000 /home/mssql/backup_db_ams_"$timestamp".bz2 sysadmin@172.16.41.15:/zbackup/mssql/db_ams/data/" >> send_backup.sh;
echo "rm /home/mssql/backup_db_ams_"$timestamp"" >> send_backup.sh;
echo "rm /home/mssql/backup_db_ams_"$timestamp".bz2" >> send_backup.sh;

cmd="sh /home/mssql/send_backup.sh";
eval $cmd;

2. Jalanin 
ssh-keygen -t rsa
<enter>
<enter>

ssh-copy-id sysadmin@172.16.41.15

3. Run script backup