How to schedule an automatic backup in Windows server?
We use the Windows task scheduler to run the mysqldump utility nightly similar to the following:
<mysql_install_dir>\bin\mysqldump" --verbose --user=<backup_user> --password=<backup_user_password> --events --triggers --routines --all-databases > <directory_storing_db_dumps>\mysql_all_databases.sql 2>> <logfile_of_backup_jobs>
That’s great! But, how do we know our <backup_user> and their password?
We set up a user in our MySQL database specifically for the backup task. There is a Backup Admin role in MySQL for this purpose. I think we found that we had to add SELECT, SHOW VIEW and SHOW DATABASES permissions also, but I may be mistaken about that.