MySQL-Backup-Manager icon indicating copy to clipboard operation
MySQL-Backup-Manager copied to clipboard

Add --hex-blob for safe blob backups

Open AronVanAmmers opened this issue 8 years ago • 0 comments

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.

AronVanAmmers avatar Nov 05 '17 20:11 AronVanAmmers