10-10-2020, 09:59 AM
#!/bin/sh
backup_dir=/home/backup/db_mysql_5
backup_file_name=db_$(date "+%Y%m%d_%H%M%S").tar.gz
databases=("Database_1" "Database_2")
db_user='DBUser'
db_password='password'
db_port='3306'
sendmail='yes'
smtp_host='192.168.1.2'
smtp_port='25'
smtp_auth_user='example@company.com'
smtp_auth_pass='password'
mail_subject='[Database Notification]: Database backup completed'
mail_from='example@company.com'
mail_to='example@company.com'
mail_body='Database backup completed'
cd ${backup_dir}
for i in "${databases[@]}"
do
/mysql/5.7.28/./my sqldump -u ${db_user} -p${db_password} -P ${db_port} --socket=/tmp/mysql_sandbox3306.sock --routines ${i} > ${backup_dir}/${i}_full.sql
/mysql/5.7.28/./my sqldump -u ${db_user} -p${db_password} -P ${db_port} --socket=/tmp/mysql_sandbox3306.sock --routines --no-data ${i} > ${backup_dir}/${i}_schema.sql
#echo 'Test'
done
/mysql/5.7.28/./my sqldump -u ${db_user} -p${db_password} -P ${db_port} --socket=/tmp/mysql_sandbox3306.sock --routines mysql > ${backup_dir}/mysql.sql
tar -czvf ${backup_dir}/${backup_file_name} ${backup_dir}/*.sql
cp ${backup_dir}/${backup_file_name} /home/any/db_mysql_5/
rm -rf ${backup_dir}/*.sql
if [ ${sendmail} = "yes" ]
then
mail -s "${mail_subject}" -r "${mail_from}" -S smtp="smtp://${smtp_host}:${smtp_port}" -S smtp-auth=login -S smtp-auth-user=${smtp_auth_user} -S smtp-auth-password=${smtp_auth_pass} -S sendwait "${mail_to}" <<< "${mail_body}"
fi
backup_dir=/home/backup/db_mysql_5
backup_file_name=db_$(date "+%Y%m%d_%H%M%S").tar.gz
databases=("Database_1" "Database_2")
db_user='DBUser'
db_password='password'
db_port='3306'
sendmail='yes'
smtp_host='192.168.1.2'
smtp_port='25'
smtp_auth_user='example@company.com'
smtp_auth_pass='password'
mail_subject='[Database Notification]: Database backup completed'
mail_from='example@company.com'
mail_to='example@company.com'
mail_body='Database backup completed'
cd ${backup_dir}
for i in "${databases[@]}"
do
/mysql/5.7.28/./my sqldump -u ${db_user} -p${db_password} -P ${db_port} --socket=/tmp/mysql_sandbox3306.sock --routines ${i} > ${backup_dir}/${i}_full.sql
/mysql/5.7.28/./my sqldump -u ${db_user} -p${db_password} -P ${db_port} --socket=/tmp/mysql_sandbox3306.sock --routines --no-data ${i} > ${backup_dir}/${i}_schema.sql
#echo 'Test'
done
/mysql/5.7.28/./my sqldump -u ${db_user} -p${db_password} -P ${db_port} --socket=/tmp/mysql_sandbox3306.sock --routines mysql > ${backup_dir}/mysql.sql
tar -czvf ${backup_dir}/${backup_file_name} ${backup_dir}/*.sql
cp ${backup_dir}/${backup_file_name} /home/any/db_mysql_5/
rm -rf ${backup_dir}/*.sql
if [ ${sendmail} = "yes" ]
then
mail -s "${mail_subject}" -r "${mail_from}" -S smtp="smtp://${smtp_host}:${smtp_port}" -S smtp-auth=login -S smtp-auth-user=${smtp_auth_user} -S smtp-auth-password=${smtp_auth_pass} -S sendwait "${mail_to}" <<< "${mail_body}"
fi