[wp-trac] [WordPress Trac] #50224: utf8mb4 issue for backups

[WordPress Trac]

#50224: utf8mb4 issue for backups
----------------------------------------------+----------------------------
 Reporter:  h20live                           |      Owner:  (none)
     Type:  defect (bug)                      |     Status:  new
 Priority:  normal                            |  Milestone:  Awaiting
                                              |  Review
Component:  General                           |    Version:  5.4.1
 Severity:  normal                            |   Keywords:  needs-testing
  Focuses:  administration, coding-standards  |
----------------------------------------------+----------------------------
 Hi, Currently when emojis are used within custom tables they appear to
 work on the site but disappear on backups when restoring or creating a
 staging site - either being replaced with "?" or losing the whole custom
 table due to one emoji being used.

 Is there any guidance available for correct database settings for
 WordPress and utf8mb4 (assuming this is the issue)?

 I'm with Closte hosting and they've been able to resolve this for two
 weeks. Until this is resolved my backups are unusable.

 General
 Server connection collation: utf8mb4_unicode_ci

 Database server
 Server: Localhost via UNIX socket
 Server type: MariaDB
 Server version: 10.3.22-MariaDB-cll-lve - MariaDB Server
 Protocol version: 10
 Server charset: UTF-8 Unicode (utf8)

 Web server
 LiteSpeed
 Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503 - ...
 PHP extension: mysqli Documentation
 PHP version: 5.6.40

 phpMyAdmin
 Version information: 4.4.10

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/50224>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform