Support » Plugin: UpdraftPlus WordPress Backup Plugin » Lost some of emoji after restoring database

  • Resolved keeeper

    (@keeeper)


    Hi,

    Thanks for the great plugin.
    I recently faced an issue after restoring database using Updraft. Some of the emoji have been replaced to ????, some of emoji are ok. Wp_posts endocing is utf8mb4.
    When talking about emoji I mean 🙂🍒🔆

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Contributor DNutbourne

    (@dnutbourne)

    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.

    keeeper

    (@keeeper)

    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 12 months ago by  keeeper.
    Plugin Contributor DNutbourne

    (@dnutbourne)

    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');
    keeeper

    (@keeeper)

    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?

    Plugin Contributor DNutbourne

    (@dnutbourne)

    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.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Lost some of emoji after restoring database’ is closed to new replies.