Opened 5 years ago
Closed 5 years ago
#50224 closed defect (bug) (invalid)
utf8mb4 issue for backups
| Reported by: |
|
Owned by: | |
|---|---|---|---|
| Milestone: | Priority: | normal | |
| Severity: | normal | Version: | 5.4.1 |
| Component: | Database | Keywords: | needs-testing |
| Focuses: | administration | Cc: |
Description
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
Hi there, welcome to WordPress Trac! Thanks for the ticket.
Please note that this Trac is used for enhancements and bug reporting for the WordPress core software, not for individual support questions.
Please try the support forums to get help with creating backups: https://wordpress.org/support/forums/.