Bug #90023 [Feature request] Shape File import/export tool
Submitted: 12 Mar 2018 13:51 Modified: 14 Mar 2018 4:38
Reporter: Yoshiaki Yamasaki Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: GIS Severity:S4 (Feature request)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: gis

[12 Mar 2018 13:51] Yoshiaki Yamasaki 
Description:
I want to import/export shape file to MySQL. Therefore, I hope MySQL has shape file import/export tool such a shp2pgsql/pgsql2shp.

 * PostGIS 2.0 pgsql2shp shp2pgsql Command Line Cheatsheet
   http://www.bostongis.com/pgsql2shp_shp2pgsql_quickguide.bqg

 * QGIS documentation : 16.3. Lesson: Import and Export
   https://docs.qgis.org/2.14/en/docs/training_manual/spatial_databases/import_export.html

In Japan, many PostGIS user who is interested in MySQL 8.0 GIS feature needs this feature.

How to repeat:
N/A

Suggested fix:
Please check "Description".
[14 Mar 2018 4:38] MySQL Verification Team 
Hello Yamasaki-San,

Thank you for the report and feature request!

Thanks,
Umesh
[20 Nov 2019 7:03] shiro ochiai 
This is very important issue.
[30 Dec 2019 13:21] Hajime Miyauchi 
I developed import tool.
Please try it.

https://github.com/hajime-miyauchi/shp2mysql
[13 Oct 2022 13:09] Daniël van Eeden 
This might be a duplicate of this bug:
Bug #7638 	Tool like PostGIS's SHP2SQL
[13 Oct 2022 13:13] Daniël van Eeden 
GDAL seems to be a common tool for this:
https://gdal.org/drivers/vector/mysql.html

Another option might be to convert to geojson and use that to import to MySQL