• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
sharadchhetri.com

sharadchhetri.com

Linux,Cloud Computing And DevOps

  • Home
  • Linux
  • CloudComputing
    • Introduction Cloud Computing
    • Amazon AWS
  • Free E-Books
  • About Me

send email after mysql backup through bash script in simple way

June 30, 2013 by Sharad Chhetri Leave a Comment

send email after mysql backup through bash script in simple way

In Facebook group one of the user asked this question “how to send email after mysql backup through bash script”.
If you know bash scripting a bit it is just a one liner.
It can be write in more advanced form but here I am using just simple method which is applicable and tested in Red Hat,CentOS, Debian and Ubuntu.

You can use this script in crontab also and schedule it as per your requirement.

Step 1: Create a bash script with file name called db-backup.sh

Note: replace the value like mysql-username,password,database-name, as per your server information.
Change emailid@example.com with your email id.

db-backup.sh

#!/bin/bash

mysqldump -u mysql-username -p password database-name > serverDB.`date +%F_%T`.sql && echo "the mysqldump has been completed- status received at `date +%F_%T`|mail -s mysqldump-status emailid@example.com

Step 2: give it read,write and execute permission only to owner.

chmod 700 db-backup.sh

Step 3: Now you can execute the script directly or can be used in crontab

sh db-backup.sh

Do'nt be greedy, share the knowledge!

  • Click to share on Facebook (Opens in new window)
  • Click to share on WhatsApp (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • Click to share on Pocket (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)

Related

Filed Under: Linux, mysql, Tips And Tricks Tagged With: bash script, mysql

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Follow Us

  • Facebook
  • Twitter
  • GitHub
  • YouTube

Recent Posts

  • How to install Java (OpenJDK) on Ubuntu Linux
  • How to install Groovy on Ubuntu 20.04 LTS
  • How to Disable selinux in Red Hat or CentOS
  • How to remove date from WordPress Post URL
  • How to install Mariadb 10.4 server on CentOS 8 / RHEL 8

Top Posts & Pages

  • How to delete mail queue in Postfix
  • How to fix read only USB pen drive in Ubuntu
  • 4 different commands to check the load average in linux
  • How to start / stop / restart / reload iptables on CentOS 7 / RHEL 7
  • How to set hostname and FQDN on CentOS 7 and RHEL 7
  • How to find absolute path of command on Linux / Unix : which command
  • How to create Jenkins user by command line and GUI
  • How to install MySQL Server 5.6 on CentOS 7 / RHEL 7
  • How to setup Jenkins Credentials for Git repo access
  • make command not found in linux CentOS Red Hat ubuntu Debian

DevOps Posts

  • vagrant cloud flow

    Install Vagrant on Ubuntu and create first VM

  • git jenkins credential github

    How to setup Jenkins Credentials for Git repo access

  • terraform

    how to install terraform in Linux : CentOS-Ubuntu

  • docker image

    How to create Ubuntu docker base image

  • Install Ansible on Ubuntu / CentOS / RHEL

Footer

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Sharad Chhetri is an experienced Linux - Cloud Engineer & freelancer. Working on Open Source Technology since RHEL 4.0 (Red Hat Enterprise Linux). He loves sharing the knowledge which earned from real scenarios. Don't be surprised if you find him in technology seminars and meetup groups. You can contact him on email for freelance projects at admin@sharadchhetri.com. Read More…

Tags

Amazon AWS apache automation awk bash script CentOS centos 7 debian devops docker freebsd ftp ghost git grep hostname jenkins kvm linux linux command linux commands MariaDB Server mysql Nagios nginx Octopress owncloud Owncloud 6 php postfix postgres python Red Hat rpm sed selinux ssh swap ubuntu user management vagrant varnish virtualbox vsftp wordpress

Recent Comments

  • Sharad Chhetri on How to install own git server with ssh and http access by using gitolite and gitweb in CentOS
  • Slacker on How to fix read only USB pen drive in Ubuntu
  • Possum on setfacl: Option -m: Invalid argument near character 3
  • UnixNewbie on How to start / stop / restart / reload iptables on CentOS 7 / RHEL 7
  • sop on How to set hostname and FQDN on CentOS 7 and RHEL 7
  • sunil on Managing Jenkins plugins from command line and GUI
  • Corneliu Florea on How to fix read only USB pen drive in Ubuntu
  • Corneliu Florea on How to fix read only USB pen drive in Ubuntu

Copyright © 2009 - 2021 · All Rights Reserved sharadchhetri.com · · Privacy Policy ·
· sitemap.xml · ·The content is copyrighted to sharadchhetri.com and may not be reproduced on other websites without our permission. ·

Copyright © 2021 · Genesis Sample on Genesis Framework · WordPress · Log in