Lost some of emoji after restoring database

Hi,

Please could you send us a copy of the restoration log? This can be found in the ‘wp-content/updraft’ directory via FTP.

The contents will be too long to post here directly, but you can use an online service such as Pastebin, and post the link here.

Hi,

Sorry for the delay.

1. Here is the page before database restoration:

Pasting its content here: This is a test page?????????????????

2. Here is the page after the restoration:

Pasting its content here: This is a test page?????????????????????????????????

The log file: https://pastebin.com/raw/pP3g9QBE

• This reply was modified 7 years, 8 months ago by keeeper.

Hi,

Please could you check the Database Charset in your wp-config.php file on the new site?
e.g.

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8mb4');

Hi,

It was:
define('DB_CHARSET', 'utf8');
After reading your last post I’ve changed it to
define('DB_CHARSET', 'utf8mb4');

Now database restoration does not cause emoji loss, thanks.
Is config file change the only thing needed to avoid the issue?

Hi,

Yes, this should be the only thing that needs changing if migrating from a site where the emoji worked correctly.

Hi,

Thanks a lot for the reply and help.