Automatic Database Backup in Mysql with the help of Batch file

To take backup in MySql we have to use following steps,

        1.Open a Notepad, then Place your Backup Script as given in figure.

        2.Then, go to file in notepad and select  ‘Save as..’ and give name for your Batch file.

For Example,

        Mybackup and save with .bat format as shown in figure.

        Add your batch file  in scheduler using instruction given below.

Schedule a task to take back up every day

You must be logged on as an administrator to perform these steps. If you aren't logged on as an administrator, you can only change settings that apply to your user account.

If you use a specific program on a regular basis, you can use the Task Scheduler wizard to create a task that opens the program for you automatically according to the schedule you choose. For example, if you use a financial program on a certain day each month, you can schedule a task that opens the program automatically to avoid the risk of forgetting to open it yourself.

1.   Open Task Scheduler by clicking the Start button , clicking Control Panel, clickingSystem and Security, clicking Administrative Tools, and then double-clicking Task Scheduler.‌  If you're prompted for an administrator password or confirmation, type the password or provide confirmation.

2.   Click the Action menu, and then click Create Basic Task.

3.   Type a name for the task and an optional description, and then click Next.

4.   Do one of the following:

·         To select a schedule based on the calendar, click Daily, Weekly, Monthly, or One time, click Next; specify the schedule you want to use, and then click Next.

·         To select a schedule based on common recurring events, click When the computer starts or When I log on, and then click Next.

·         To select a schedule based on specific events, click When a specific event is logged, click Next; specify the event log and other information using the drop-down lists, and then click Next.

5.   To schedule a program to start automatically, click Start a program, and then clickNext.

6.   Click Browse to find the program you want to start, and then click Next.

7.   Click Finish.