Scripts to take MySQL 8.* full and incremental backups using mysqldump
You can take full and incremental backups of MySQL 8.* versions using the provided scripts here. This script is suitable for a standalone mysql installation, it also includes optional upload of your backup files to s3 cloud storage and encryption support. The first script is for the configuration where backup and restoration metadata or config are mentioned. The second script is to take actual backups. This script will take a full backup for the current date if no full backup exists. If it finds a full backup for the current day, it will take incremental backups as a means of taking binary log backups. Schedule the backup frequency with cron as per your requirements. backup_restore.conf – Configuration File # MySQL credentials MYSQL_USER = "myadmin" MYSQL_PASSWORD = "myadmin@123" MYSQL_HOST = "localhost" MYSQL_PORT = "3306" # Backup settings BACKUP_DIR = "/backups/mysql" FULL_BACKUP_DIR = "$BACKUP_DIR/full" INCR_BACKUP_DI...
