Solved

How to scheduled Mysql Backup & send email notification

Posted on 2012-03-16
4
499 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 21

Accepted Solution

by:
Radhakrishnan R earned 334 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 21

Assisted Solution

by:Radhakrishnan R
Radhakrishnan R earned 334 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 166 total points
ID: 37733001
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

752 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