Opened 13 years ago
Closed 13 years ago
#3318 closed bug (wontfix)
OGR converter and MySQL
Reported by: | jbogdani | Owned by: | jef |
---|---|---|---|
Priority: | major: does not work as expected | Milestone: | Version 1.7.0 |
Component: | Vectors | Version: | |
Keywords: | Cc: | timlinux | |
Must Fix for Release: | No | Platform: | All |
Platform Version: | Awaiting user input: | no |
Description
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"
I suggest removing the plugin before releasing QGIS 1.7