[QGIS-trac] [Quantum GIS] #3318: OGR converter and MySQL

Quantum GIS qgis at qgis.org
Sat Dec 11 10:33:16 EST 2010


#3318: OGR converter and MySQL
------------------------------------------------+---------------------------
   Reporter:  jbogdani                          |              Owner:  jef          
       Type:  bug                               |             Status:  new          
   Priority:  major: does not work as expected  |          Milestone:  Version 1.7.0
  Component:  Vectors                           |            Version:               
   Keywords:                                    |   Platform_version:               
   Platform:  All                               |           Must_fix:  No           
Status_info:  0                                 |  
------------------------------------------------+---------------------------
 I tried to use OGR Converter plugin to save a shapefile in MySQL. There is
 no way to make it work. I Tried different syntaxes for mysql connection,
 but no way. This one:
 MySQL:mydb,host=localhost,user=myuser,password=mypasswd,port=3306
 takes few time to execute before "Could not establish connection" error
 appears.
 Anyway I'm able to run successfully ogr2ogr.exe (WIN) on command line and
 it works: syntax for cli is (as in
 http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatsheet):
 ogr2ogr -f "MySQL"
 MYSQL:"mydb,host=localhost,user=myuser,password=mypasswd,port=3306" -nln
 "tmp" -a_srs "EPSG:32638" "path/to/shapefile.shp"

-- 
Ticket URL: <http://trac.osgeo.org/qgis/ticket/3318>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats


More information about the QGIS-trac mailing list