Solved

How to scheduled Mysql Backup & send email notification

Posted on 2012-03-16
4
484 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 21

Accepted Solution

by:
RK 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:RK
RK 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

840 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