title: MySQL 5.7.12 import cannot create a JSON value from a string with CHARACTER SET 'binary'
body: <p>I exported my database with JSON columns in it. After I migrated to a new server, my import crashed every time with an error like:</p>
  
  <blockquote>
    <p>cannot create a JSON value from a string with CHARACTER SET 'binary'</p>
  </blockquote>
  
  <p>On stackoverflow, I found this post but didn't work for me:
  <a href="https://stackoverflow.com/questions/36178312/mysqlimport-issues-set-character-set-database-binary-which-prevents-loading">mysqlimport issues &quot;set @@character_set_database=binary&quot; which prevents loading json values</a></p>
  
  <p>The file is 2GB and isn't possible to open the file.</p>
  
  <p>Anyone has an idea to import my database file?</p>