Scheduled Data Backup
Applicable to self-built minio environment
yaml
mysql_backup:
enabled: false
bucket: finclip-db-backupAfter enabling this configuration, a full backup of MySQL data is performed daily at 0:00 and uploaded to the specified minio bucket, with a retention period of 30 days.
Restore Data
Method for restoring MySQL database The mysql command is an official MySQL command-line tool for database recovery. The following are the steps for restoring a database using the mysql command:
shell
1. Login to minio, download backup file from http://ip:9000
2. Import full backup data: mysql -u username -p database_name < backup_file.sql