[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