0

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?

Improve this question
2
  • 1
    Have you tried using --hex-blob in mysqldump ?
    – Ergest Basha
    Commented Mar 10, 2023 at 20:07
  • @ErgestBasha that seems to have resolved it. Many thanks.
    – adam78
    Commented Mar 10, 2023 at 20:47

0

Reset to default

Your Answer

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

Browse other questions tagged or ask your own question.