title: How to correct "Cannot get geometry object from data you send to the GEOMETRY field" when restoring a PHPMyAdmin backup?
body: <p>I have a few databases that use POINT fields in MySQL to store geometry data. All the data is added in the same way:</p>
  
  <pre><code>GeomFromText( 'POINT( lat lng )' )
  </code></pre>
  
  <p>All the databases backup and restore without problems except for one. This database is on the same server as the others, but in a separate CPanel account.</p>
  
  <p>When I try to restore that database, I get this error:
  "Cannot get geometry object from data you send to the GEOMETRY field"</p>
  
  <p>An example of the insert statement is:</p>
  
  <pre><code>INSERT INTO `location` (`id`, `coords` , `new_coords`) VALUES
  (1, '\0\0\0\0\0\0�a��[XJ@�˶x��', '\0\0\0\0\0\0�8z�%XJ@g�+����' ),
  (3, '\0\0\0\0\0\0�n�w�/J@6���', '\0\0\0\0\0\0�n�w�/J@6���' ),
  (4, '\0\0\0\0\0\0�  ��@J@.����', '\0\0\0\0\0\0� ��@J@.����');
  </code></pre>
  
  <p>I have checked the data and it all seems to show valid latitudes and longitudes when I run this query:</p>
  
  <pre><code>SELECT X( coords ) , Y( coords ) FROM location
  </code></pre>
  
  <p>A few of the records return 0 and 0. So I tried updating those to NULL and I still get the same error.</p>
  
  <p>When I try to export with or without the "Dump binary columns in hexadecimal notation" option ticked, I also get the same error.</p>
  
  <p>Is there a setting that can cause this issue or is it just going to be something in the data?</p>
  
  <p>If it's the data, what would the fix be?</p>
  
  <p>Thanks in advance :)</p>
  
  <p>This is exporting from a Linux MariaDB server (10.1.37-MariaDB) on PHP 7.2.7 using PHPMyAdmin 4.8.3 and importing on to WAMPServer 3.1.4 (10.3.9-MariaDB) using PHP 7.2.10 using PHPMyAdmin 4.8.3.
  Please note, this also did not work on WAMPServer 3.0.8</p>