mysqlimport or LOAD DATA INFILE with Multipoint datatype

Question

11.30K viewsSeptember 16, 2022mariadb multipoint mysql spatial

0

saladi September 12, 2022 0 Comments

I have a column in a table that has type multipoint. How do I structure the data in my file to either use mysqlimport or the LOAD DATA INFILE construct to import this file?

Right now my data is in a plaintext json-formatted file (not in a database) and I would like to structure it to be compatible for import.

I am using MariaDB 15.1

1 Answer

score 1 · Answer 1 · 2022-09-13T03:53:15+00:00

Probably this is all you need:

mysqldump --hex-blob ...

A subsequent reload using mysql should be able to exactly reconstruct the data.

LOAD DATA would need some extra code to deal with the conversion — either geomFromText or unhex. That should be possible; do you prefer LOAD DATA?