I have MySQL 8 database with some tables that have some column of type GEOMETRY.

When I back up the table with mysqldump, it outputs my geometry column as _binary '\æ\0\0\... and when I try to restore the dump to fails with an error:

"Cannot get GEOMETRY object from the data you send to the Geometry field".

Any ideas how to resolve?

  • 1
    Have you tried using --hex-blob in mysqldump ? Mar 10 at 20:07
  • @ErgestBasha that seems to have resolved it. Many thanks.
    – adam78
    Mar 10 at 20:47


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.