How to Backup MySQL Databases Automatically? | Windows | Daily, Weekly, Monthly Backups

A simple and easy way to automatically backup your #MySQL Databases on regular intervals.

We are going to use simple "mysqldump" command and a batch script (.bat) file for generating backup and then with the help of Task Scheduler on Windows, we are going to set it to repeat at particular time specified. You can backup single database as well as multiple databases at the same time and also complete instance of your MySQL can be backed up.

Hope you find it useful!

#backup

[uosldtf]

Thank you for this video. Really helpful

[findingthecontent]

Thank you so much for this video. It was so helpful🙏

[gqkszoh]

thank you a lot to make it this simple

[ulohhijbuloh]

done good thank, but how to backup only database choose by self? not all database exactly. thanks

[rohitmathur]

Thanks, In script how can we add date/time to backup file, so daily backups have different names.

[rootdefault]

nice video thanks. Qsn is there a way to push the file to a remote server. (the created SQL and logfile)

[StephenOpia]

Thank u for this video. Really helpful. My backups overwrite and has no date and timestamp on it. Pls how can i include these as part of the batch script. Its really urgent. Thank u

[sarpgursoy]

I wish you had enabled word wrap so that we could see the entire code you wrote.

[shivkumarmadkar]

Hi sir i want to download mysql database on C panel hostinger how can i do this pls solution?

[cairorodrigosohn]

Very good video. How can I back up a specific database?

[soumajeetroy]

If I set the task time at 10 am, will the task start even if I don't start my pc.

[oxpgxnd]

Thanks>> whay backup with this method abig size file ?!!!