WordPress.org

Make WordPress Core

Opened 6 days ago

Closed 6 days ago

#50224 closed defect (bug) (invalid)

utf8mb4 issue for backups

Reported by: h20live 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

Change History (1)

#1 @SergeyBiryukov
6 days ago

  • Component changed from General to Database
  • Focuses coding-standards removed
  • Milestone Awaiting Review deleted
  • Resolution set to invalid
  • Status changed from new to closed

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/.

Note: See TracTickets for help on using tickets.