How to Import shape file into MySQL

mysql import spatial shapefile
PhantomM picture PhantomM · Feb 27, 2013 · Viewed 17.4k times · Source

I need to import the spatial data in shape file into MySQL tables. I am able to import into PostGreSQL. Any pointers for MySQL. I need the data in MySQL table.

Answer

phipex picture phipex · Mar 16, 2013

try this whit FWtool instaled

ogr2ogr -f MySQL MySQL:database_name,host=localhost,user=root,password=1234 C:\route_path\line.shp -nln datatable_name -update -overwrite -lco engine=MYISAM

try install for better result in any proces Osgeo4w

http://trac.osgeo.org/osgeo4w/

Related questions

How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How can I import a database with MySQL from terminal?

How can I import a database with mysql from terminal? I cannot find the exact syntax.

Read More
Import SQL file into mysql

I have a database called nitm. I haven't created any tables there. But I have a SQL file which contains all the necessary data for the database. The file is nitm.sql which is in C:\ drive. This file has …

Read More