SQL export uses bad char set ‘utf8mb4’

  • Resolved tbulb

    (@tbulb)


    7 years, 9 months ago

    Hi,

    i just downloaded this plugin and tried to backup my database. I’m importing the DB for moving a WordPress site to a new server (Virtualmin). The SQL execute / import command gives me this error:
    ERROR 1115 (42000) at line 11: Unknown character set: ‘utf8mb4’

    the import stalls and won’t proceed.

    please advise…

    thanks!

Viewing 1 replies (of 1 total)
  • Plugin Contributor Katrina “Kat” Moody

    (@katmoody)

    Basically this means that your database was exported and encoded using the utf8mb4 character set, which is newer and supports encoding for emojis, etc.

    So one site has encoded or saved all the characters using a specific set of data points while the other site is wanting to read it using a different set (well they’re saying it’s unknown, so it might not be installed or enabled on their phpmyadmin system depending on how old it is).

    You either need to specify a different character set (maybe the baseline utf8) in your other database (not positive how to do that but your old site’s host should be able to help you; or you need to specify the utf8mb4 character encoding when you import it into your new database. If that character set isn’t available then you might talk with the new host and see if it can be added or not.

    Hopefully that helps you get this resolved between your two sites.

    Kat

Viewing 1 replies (of 1 total)
  • The topic ‘SQL export uses bad char set ‘utf8mb4’’ is closed to new replies.