Mysql Backup Scheduling in Windows

Mysql Backup Scheduling in Windows

1.Write mysql dump query in text file

mysqldump -u <user_name> -p<password> --all-databases --routines --single-transaction > "<Path to store\file.sql>"

Example:

mysqldump -u root -proot --all-databases --routines --single-transaction > "E:\Mysql\backup\full\dump201801091125.sql"

2. save with .bat extension

3. goto task schedular(u will get by typing name in search bar)

4. Action>create new task> general

give name

5. trigger

New

set time

6. Actions

give bat file path

7. Ok

Verify

Go to task schedular

Click on Task scheduler Library

here you can find your task name

right click on your task name and click on Run

Go to store path and check backup file