cbaerike / MySQL-Backup-Manager

MySQL Backup Manager is a simple software solution for backing up MySQL Databases automatically. It uses a Windows service for the backup process and has an GUI attached for administrating which databases needs backup
http://martin-rohwedder.github.io/MySQL-Backup-Manager/
27 stars 7 forks source link

Add --hex-blob for safe blob backups #23

Open AronVanAmmers opened 6 years ago

AronVanAmmers commented 6 years ago

Without --hex-blob, mysqldump exports blob and longblob fields as UTF-8 text strings. These can't always be restored properly. Using --hex-blob resolves this.

The downside is that backup files with blob data grow larger. IMO that's worth it; reliability of backups is more important than the space efficiency.