#282 can't export MySQL POINT type

closed-fixed
MySQL (68)
5
2013-04-27
2012-11-01
No

While browsing table data, the POINT fields are shown just fine (" POINT(49.1125051 16.3618832) ") but when I try to Dump the same table, the result is something like

(1, 'test', ^@^@^@^@^A^A^@^@^@^M<91>.<91>f<8E>H@<CA><F8><9C>`<A4>\0@, 'Kopečná 20', NULL, '2012-10-18 18:56:05'),

which is clearly wrong and can't be imported.

When I dump the same data with mysqldump, the output is
(1,'test','\0\0\0\0^A^A\0\0\0\r<91>.<91>f<8E>H@<CA><F8><9C>`<A4>\\0@','Kopečná 20',NULL,'2012-10-18 16:56:05'),
- the same data but quoted and with NULs and backslashes escaped. That can be imported.

Still present in 3.6.1.
Thanks

Discussion

  • Anonymous - 2012-11-22

    Ok, any progress?

    Since it appears that because phpmyadmin output, while techincally valid SQL is not valid UTF-8 and thus can't be imported properly and while mysqldump supports --hex-dump there's no way to do that for POINT .. there's no sane way to actually dump a mysql table with POINTs anywhere (except that I can use adminer to dump to csv and then translate that to SQL so it can be imported again).

    So I'll start working on a patch that makes adminer export POINT fields as POINT(%F, %F) .

     
  • Anonymous - 2012-11-22

    Fixed. Dumping as POINT(%F, %F) proved to be uselessly difficult, instead dumping as hex data.
    Pull request (commit fa64ec792ba65ab74659c55f197bd3a76126174a) should appear on github shortly.

     
  • Jakub Vrána

    Jakub Vrána - 2013-04-27

    Thank you for the report, I've fixed it in Git. You can download the "Current development version" from http://www.adminer.org/#download

     
  • Jakub Vrána

    Jakub Vrána - 2013-04-27
    • status: open --> closed-fixed
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks