MySQL Reference Manual :: 5.8.2.3 Backup Strategy Summary

Always run the MySQL server with the --log-bin option, or even --log-bin=log_name, where the log file name is located on some safe media different from the drive on which the data directory is located. If you have such safe media, this can also be good for disk load balancing (which results in a performance improvement).

Make periodic full backups, using the last mysqldump command given earlier that makes an online, non-blocking backup.

Make periodic incremental backups by flushing the logs with FLUSH LOGS or mysqladmin flush-logs.