The module currently adds this to all MySQL dump files:
SET NAMES utf8;
This should be "utf8mb4" if the site has been upgraded to that format, otherwise reimporting the database could result in minor corruption.

CommentFileSizeAuthor
#3 backup_migrate-n3143250-3.patch872 bytesDamienMcKenna
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

DamienMcKenna created an issue. See original summary.

DamienMcKenna’s picture

DamienMcKenna
Location NH, USA
CreditAttribution: DamienMcKenna at Mediacurrent commented
Title: Detect whether to use utf8 or utf8mb4 for MySQL files » Use utf8mb4 for MySQL files

Thinking through it more, it might be useful to just make all backups utf8mb4 instead.

DamienMcKenna’s picture

DamienMcKenna
Location NH, USA
CreditAttribution: DamienMcKenna at Mediacurrent commented
Status: Active » Needs review
FileSize
backup_migrate-n3143250-3.patch872 bytes

This just makes the files utf8mb4.

DamienMcKenna’s picture

DamienMcKenna
Location NH, USA
CreditAttribution: DamienMcKenna at Mediacurrent commented
Parent issue: » #3116785: Plan for Backup and Migrate 7.x-3.8

  • DamienMcKenna committed 44a6725 on 7.x-3.x 
    Issue #3143250 by DamienMcKenna: Use utf8mb4 for MySQL files.
DamienMcKenna’s picture

DamienMcKenna
Location NH, USA
CreditAttribution: DamienMcKenna at Mediacurrent commented
Status: Needs review » Fixed

Committed.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.