Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have used Grass GIS imported a .shp file; I now want to export this file to MySQL.

I understood that MySQL will contain the function of all three the files necessary in a Shape file system (.shp - .db - .shx). The import works fine but when I try to export to MySQL I get the following error.

ERROR: Unable to open OGR data source 'Test'

At some stage there was also a message that indicated that MySQL or MySQL Spatial is not available.

I have not used Quantum GIS before; I do however have purchased Globalmapper and want to use MySQL instead of Shapefiles. The database is too big to recapture all the info in MySQL I will have to find a way to convert the data.

share|improve this question
    
The data source is not input data, your shapefile ? If yes, check your shp –  twisig Feb 23 at 13:13
add comment

1 Answer 1

Your best bet is to use OGR directly from the command line. OGR's MySQL Driver page has an example of how to use ogr2ogr to import a shapefile:

http://www.gdal.org/ogr/drv_mysql.html

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.