Create backups of MySQL databases and servers

Question

I understand MySQL database backup, but how to back up the entire MySql configuration and database?

I'm building several sets of services/tools and I need to provide instructions so that less technical people can restore them in my absence. One of the things I need to back up is self-hosted MySql.

Can I compress only the MySql folder and the ProgramData MySql folder? Will this be a complete recovery solution? Just unzip and run the service?

Answer 1

In fact, the easiest way is to use crontab shell. Of course, there are also many paid software that can achieve this. If you want to back up, it is recommended that you back up your data files and configuration files so they can be restored. This is also the safest. The backup of mysql installation files is of little significance because it can be downloaded from the official website at any time.