Best Practice to perform Mysql 5.7 Databases Schedule Backup

1592990

Dear ,

I need to now the Best and prefer the best Practice  to perform Schedule Backup for MySQL 5.7 Database on Windows Server.

Thanks

Dave Stokes-MySQL Community Team-Oracle

There any many examples of using the Windows scheduler to run a batch job that can be found by searching the Internet.

But before you start make sure you know how long you have to retain the data (company policy, legal regulations).  Have an established retention policy that includes an off site storage of data.

If the backups are infrequent, you should also save the binary logs so you can do incremental restorations for data changes after the backup.

1592990

Hi,

For mysql 5.7 databases schedule backup on windows server I am using backup script from https://www.redolive.com/utah-web-designers-blog/automated-mysql-backup-for-windows/

This script is running fine only the security Issue, this script is using root user with password.

is there any alternate best way to perform schedule backup without using password in the script?

GUI provided by oracle like work bench 6.3 but I didn't find any option for schedule backup for free.

Please suggest me.