title: How to take a dump from Mysql 8.0 into 5.7?
body: <p>I would like to take a dump from Mysql 8.0.11 and restore it into 5.7.27.</p>
  
  <p>When I tried to restore it I got the error:</p>
  
  <blockquote>
    <p>ERROR 1273 (HY000) at line 25: Unknown collation: 'utf8mb4_0900_ai_ci'</p>
  </blockquote>
  
  <p>Then I tried to use the compatible flag to make it easier on an older MySQL DB.</p>
  
  <pre><code>mysqldump --compatible=mysql4 --add-drop-table -u r00t -h xxx.eu-north-1.rds.amazonaws.com -p radius_db &gt; ~/radius.sql
  </code></pre>
  
  <p>But that doesn't seem to work either:</p>
  
  <blockquote>
    <p>mysqldump: Couldn't execute '/*!40100 SET @@SQL_MODE='MYSQL40' */':
    Variable 'sql_mode' can't be set to the value of 'MYSQL40' (1231)</p>
  </blockquote>
  
  <p>Any advice would be appreciated.</p>