How to take MySql backup with schedule and success and failure notification

-

 

Following script can be used to take MySql Backup: 

 @echo on  
 For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set mydate=%%b-%%a-%%c)  
 For /f "tokens=1-2 delims=/:" %%a in ('time /t') do (set mytime=%%a-%%b)  
 mysqldump --protocol=TCP -P8081 -uusername -ppassword databasename> "C:\backup\backupfilename_%mydate%_%mytime%.sql"  
 if %ERRORLEVEL%==0 (  
      //Send your success notification  
 ) else if %ERRORLEVEL%==2 (  
      //Send your failure notification   
 )

Here first two line is to get date and time after that we use mysqldump to backup the database, providing protocol, username, password and database name and phisical address of the backup file. See mysqldump documentation for more information. 

After backup process completed ERRORLEVEL variable contains the status of the backup if backup is success the value will be 0, for error it will be 2 and if there is any warning then 1. So you can easily send the notification by checking the value.   

Now you can create a batch file with this script and put in in the task scheduler of server.

Comments

Post a Comment

Popular posts from this blog

Understanding the Difference Between Assembly Order and Production Order in Dynamics 365 Business Central

-
Image
Among various manufacturing features, Assembly Orders and Production Orders play a pivotal role in Microsoft Dynamics 365 Business Central. While they might appear similar, these two order types serve different purposes and cater to distinct manufacturing processes. Let’s delve into the key differences and their respective use cases. Assembly Order Assembly Orders were introduced in Microsoft Dynamics NAV 2013, An Assembly Order in Business Central is designed for simple and quick manufacturing processes where the emphasis is on combining components to create a finished product. Here are the primary characteristics: Use Case : Best suited for light manufacturing or kitting operations where items are assembled without complex operations or extensive planning. Simplified Workflow : Assembly Orders focus on assembling predefined components into a finished good with minimal overhead. This is ideal for businesses that create kits or bundles, such as electronic packaging or furniture assembl...
Read more

Microsoft Dynamics NAV - Creating and Consuming a Codeunit Web Service

-
Image
We can create any code unit in Dynamics NAV and publish it as web-service. To do that we need to go to the page (form in 2009)  "Web Services".  In the Web Services page, choose New. In the Object Type column, select Codeunit, then in the Object ID column enter the Codeunit Number, and then enter a name in the Service Name column. This name will be the web-service name to consume.  Mark the check box in the Published column and choose OK to close the New - Web Services page. Webservice Form (2009) Verifying the Web services availability. Make sure flowing services are running in server. In Browser write the service URL to check if the service published successfully, Change the localhost with ip for remote server : http://localhost:7047/DynamicsNAV/WS/Services  If everything is ok you should see the published services names in the browser. Now lets try to consume the service. In this example we will see how to consume the service fr...
Read more

Different use of AL Find Functions for Filters in Dynamics 365 Business Central

-
Image
This post provides tips about different find function in Business Central, including both long-standing C/AL strategies and newer concepts like partial records. FindSet vs FindFirst/FindLast FindSet and FindFirst/FindLast are two methods utilized in Dynamics 365 Business Central for extracting records from a table. The key distinction between them is that FindSet fetches a group of records, whereas FindFirst only fetches the initial record in the filter and FindLast fetches the last record. FindSet is employed when there’s a need to traverse through a sequence of records, and it’s advisable to use FindSet(true) if there’s a requirement to alter any record within the group. Conversely, FindFirst/FindLast is employed when only the initial or last record is needed and there’s no requirement for a loop. SetLoadFields  The SetLoadFields function only loads the specified fields, thereby not fetching the remaining fields in the table and ensuring a quicker load. It is suitable for searchi...
Read more