MYSQL import: unable to get geometry object from data sent to GEOMETRY field

Question

I recently upgraded to MySQL 5.7 and tried to start replication from the 5.6 wizard. However, replication fails with the following error:

Error 'Cannot get geometry object from data you send to the GEOMETRY field' on query. 

Turns out this also happens when I try to import data from mysqldump. The structure of the table is as follows:

  CREATE TABLE `locations` ( `location_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `country_id` int(10) unsigned NOT NULL, `name` varchar(100) CHARACTER SET utf8 NOT NULL, `locations_type_id` int(11) unsigned NOT NULL, `parent_id` int(11) unsigned DEFAULT NULL, `importance` decimal(3,2) NOT NULL DEFAULT '1.00', `lat` decimal(10,7) DEFAULT NULL, `lng` decimal(10,7) DEFAULT NULL, `radius` decimal(6,3) DEFAULT NULL, `polygon` polygon DEFAULT NULL, PRIMARY KEY (`location_id`), KEY `name` (`name`,`locations_type_id`,`parent_id`,`lat`,`lng`), KEY `locations_type_id` (`locations_type_id`), KEY `name_2` (`name`(8)), KEY `country_id` (`country_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 

It seems to me that the import is trying to insert some binary data into the polygon field, but to be honest, I have no idea how to make it work.

Any ideas?

Answer 1

If you can restart mysqldump, try adding the -hex-blob option so that all binary data is exported as a hex dump.