Skip to content

Backup MySQL Database using mysqldump and Send it to mail through Python email.

Notifications You must be signed in to change notification settings

vrmohanbabu/mysqldump-to-mail-using-python-email

Repository files navigation

Overview

  1. Backup Mysql Database and Send mail through Python email.
  2. Backup should run every day at 12 clocks by cron jobs.

Setup the Enviroment

  • Environment used is centos7.
  • Python-3.7.4
  • MYSQL 5.7

Script to install Python for centos 7:

  • sh python37-install.sh

Install Python for others:

Script to install mysql for centos 7:

  • sh mysql57_install.sh

Mail Information:

Edit send_mail.py for Email information.

  • In email['from'] - Write sender's name
  • In email['to'] - Receiver email
  • In smtp.login - Add sender's mail and password

Database Information:

Edit mysql_dump.sh

  • DBUSER
  • DBPASSWORD
  • DBNAME
  • FILELOCATION - Added the file location to create dumpfiles.

Setup Gmail:

Use cron job to automate Backup

  • crontab -e
  • 0 12 * * * sh /home/centos/mysqldump-to-mail-using-python-email/mysql_dump.sh

To Run

  • sh mysql_dump

Output Mail:

About

Backup MySQL Database using mysqldump and Send it to mail through Python email.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published