Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 QGIS before. 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 from shapefile to MySQL.

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

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:

share|improve this answer

Your Answer


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.