Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to scheduled Mysql Backup & send email notification

Posted on 2012-03-16
4
Medium Priority
?
568 Views
Last Modified: 2012-08-14
Hi Friends,

I am using Windows 2008 Server & Mysql SQL Database, Now I am taking my sql backup by running batch file on scheduled, batch file code is as per below, can anyone help me for email notification configuration, whenever batch file will execute on scheduled & Task will be success  that time I should get notification on my mail id, I have configured SMTP on same server

Thanks in Advance


@echo off
for /f "tokens=1" %%i in ('date /t') do set DATE_DOW=%%i
for /f "tokens=2" %%i in ('date /t') do set DATE_DAY=%%i
for /f %%i in ('echo %date_day:/=-%') do set DATE_DAY=%%i
for /f %%i in ('time /t') do set DATE_TIME=%%i
for /f %%i in ('echo %date_time::=-%') do set DATE_TIME=%%i
mysqldump -u helpdesk -p"Platys45" db_java > E:\Development\my_sql_hourly_backup\%DATE_DAY%_%DATE_TIME%_database.sql
0
Comment
Question by:Nilesh Havire
  • 2
4 Comments
 
LVL 23

Accepted Solution

by:
Radhakrishnan R earned 1336 total points
ID: 37732098
Hi,

You can use some third party free application to take MySql backup and send a backup status via e-mail notification.

http://www.smipple.net/snippet/mauro.artizzu/cPanel%20crontab%20to%20backup%20mysql,%20files%20with%20email%20alert

http://sourceforge.net/projects/automysqlbackup/

Hope this helps.
0
 
LVL 23

Assisted Solution

by:Radhakrishnan R
Radhakrishnan R earned 1336 total points
ID: 37732099
0
 

Author Comment

by:Nilesh Havire
ID: 37732119
I dont want to use 3rd party tool, & above link is for Linux, My script is working fine, I just want to get email notification whenever task will success


Regards
0
 
LVL 14

Assisted Solution

by:shahzoor
shahzoor earned 664 total points
ID: 37733001
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question