Bug report #3318

OGR converter and MySQL

Added by bradypus - about 14 years ago. Updated almost 14 years ago.

Status:Closed
Priority:Low
Assignee:Jürgen Fischer
Category:Vectors
Affected QGIS version: Regression?:No
Operating System:All Easy fix?:No
Pull Request or Patch supplied: Resolution:wontfix
Crashes QGIS or corrupts data: Copied to github as #:13378

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"

History

#1 Updated by Paolo Cavallini almost 14 years ago

I suggest removing the plugin before releasing QGIS 1.7

#2 Updated by Paolo Cavallini almost 14 years ago

  • Resolution set to wontfix
  • Status changed from Open to Closed

Removed as per f557e5d6 (SVN r15332)

Also available in: Atom PDF