Some emoji are not exported

  • Resolved dima2duo

    (@dima2duo)


    5 months, 3 weeks ago

    Hi. I’m facing the problem of not being able to export database via updraft with emoji ???.

    For example. This is how it looks like on the site: https://prnt.sc/ZxvfB60wQoPR
    and this is how it looks in the backup itself: https://prnt.sc/2TsRuhZIEMiJ

    The problem does not apply to all emoji, but to “more complex” ones, for example, this emoji is displayed both on the site and in the backup: https://prnt.sc/xxLUHb7buCXc.

    For the test, I did a database backup via mysqldump directly and also via the BackUpWordPress plugin. They have emoji in their backups – https://prnt.sc/p4mnEy41kXBo

    Here is the information where I do the backup:
    WordPress Version: 6.1.1 (also tried on WordPress Version: 6.5.3), running on PHP 8.0.30 (Apache), MySQL 5.7.44-48-log
    sql_mode=NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@@COLLATION_CONNECTION */;
    /*!40101 SET @OLD_SQL_MODE=@@@SQL_MODE, SQL_MODE=’NO_AUTO_VALUE_ON_ZERO’ */;
    /*!40101 SET NAMES utf8mb4 */;
    /*!40101 SET foreign_key_checks = 0 */;

    Also for the test, I deployed the site on another server with MySQL 10.3.39-MariaDB, as strange there exports well.
    What are the options to fix this problem on my server?

Viewing 4 replies - 1 through 4 (of 4 total)
Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.