title: Cannot Restore Geometry Backup MySQL 5.7 Error
body: <p>I've been upgrading a website from Mysql <code>5.6</code> to <code>5.7</code>. When restoring a backup from <code>mysqldump</code>, which has worked for 10 years (unchanged) under Mysql 5.1-5.6, it no longer works under MySQL <code>5.7</code>.</p>
  
  <p>Specifically, the first row of geometry data fails the restore:</p>
  
  <pre><code>ERROR 1416 (22003) at line 1580 Cannot get geometry object from data you send to the GEOMETRY field
  </code></pre>
  
  <p>So, this <strong>is valid geometry</strong>, but not any more.</p>
  
  <p>Remedies attempted:</p>
  
  <ul>
  <li>Switch mysqldump to <code>--hex-blob</code></li>
  <li>Try using <code>astext( &lt;some geometry&gt; )</code> before importing</li>
  <li>Tired hand loading various geometry rows from the backup, all fail</li>
  </ul>