Skip to content

Instantly share code, notes, and snippets.

@rowanwins
Created June 10, 2015 10:37
Show Gist options
  • Save rowanwins/120bf64470c89cd191a2 to your computer and use it in GitHub Desktop.
Save rowanwins/120bf64470c89cd191a2 to your computer and use it in GitHub Desktop.
Use ogr2ogr to import shp to MySQL
ogr2ogr -f "MySQL" MYSQL:"dbName,host=localhost,user=root,port=3306" -nln "tableName" -a_srs "EPSG:4326" shpName.shp -lco ENGINE=MyISAM
@vwasteels
Copy link

hello, sorry I'm newbie, but how do you install MYSQL driver for ogr2ogr ?
I get :
Unable to find driver `MySQL'.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment