How to import form file in MySQL

Question

I need to import spatial data into a form file in MySQL tables. I can import into PostGreSQL. Any pointers to MySQL. I need data in a MySQL table.

Answer 1

try this FWtool button installed

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 to set the best result in any Osgeo4w processes

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

Answer 2

I just used the ogr2ogr command line tool to import a form file into a mysql database. Verify that the database server allows external connections. If this does not happen, then it throws all kinds of errors.

After that you can use -

Select ASTEXT (Shape) POLYGON from the world to get an array of polygon coordinates, etc.