08-25-2020, 07:08 AM
#!/bin/sh
backup_dir=/backup/
backup_file_name=db_$(date "+%Y%m%d_%H%M%S").tar.gz
databases=("example")
db_user='user'
db_password='password'
db_port='3306'
sendmail='yes'
smtp_host='0.0.0.0'
smtp_port='25'
smtp_auth_user='noreply@example.com'
smtp_auth_pass='password'
mail_subject='Databse Server: Database backup completed'
mail_from='noreply@example.com'
mail_to='noreply@example.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_sandbox33065.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_sandbox33065.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_sandbox33065.sock --routines mysql > ${backup_dir}/mysql.sql
tar -czvf ${backup_dir}/${backup_file_name} ${backup_dir}/*.sql
cp ${backup_dir}/${backup_file_name} /Mybackup/Database_Backup/
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=/backup/
backup_file_name=db_$(date "+%Y%m%d_%H%M%S").tar.gz
databases=("example")
db_user='user'
db_password='password'
db_port='3306'
sendmail='yes'
smtp_host='0.0.0.0'
smtp_port='25'
smtp_auth_user='noreply@example.com'
smtp_auth_pass='password'
mail_subject='Databse Server: Database backup completed'
mail_from='noreply@example.com'
mail_to='noreply@example.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_sandbox33065.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_sandbox33065.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_sandbox33065.sock --routines mysql > ${backup_dir}/mysql.sql
tar -czvf ${backup_dir}/${backup_file_name} ${backup_dir}/*.sql
cp ${backup_dir}/${backup_file_name} /Mybackup/Database_Backup/
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