<div dir="ltr">Realized I left out which version I was on. I compiled and installed from gdal-2.0.0.tar.gz. I'm about to try gdal-2.0.1.tar.gz.<div><br></div><div>Thanks,</div><div><br></div><div>Nick</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Sep 23, 2015 at 10:29 AM, Nicholas Williams <span dir="ltr"><<a href="mailto:nicholas+osgeo@nicholaswilliams.net" target="_blank">nicholas+osgeo@nicholaswilliams.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><span style="font-size:13px">I'm having trouble getting ogr2ogr working with MySQL on Ubuntu 12.04, but I can't figure out why. Configure says MySQL is enabled, but execution says it's not.</span><div style="font-size:13px"><br></div><div style="font-size:13px">In addition to other dependencies, I installed the MySQL client dev:</div><div style="font-size:13px"><br></div><div style="font-size:13px">sudo apt-get install -y libmysqlclient-dev=5.5.28-rel29.1-334.precise<br></div><div style="font-size:13px"><br></div><div style="font-size:13px">And I confirmed that mysql_config exists and is executable:</div><div style="font-size:13px"><br></div><div style="font-size:13px"><div># ls -al /usr/bin/mysql_config</div><div>-rwxr-xr-x 1 root root 6933 Oct 25 2012 /usr/bin/mysql_config</div></div><div style="font-size:13px"><br></div><div style="font-size:13px">I configured, made and installed:</div><div style="font-size:13px"><br></div><div style="font-size:13px"><div>./configure --prefix=/usr --with-spatialite=yes --with-libjson-c=internal --with-mysql=yes</div><div>make</div><div>make_install</div></div><div style="font-size:13px"><br></div><div style="font-size:13px">The configure output suggests that MySQL support is enabled. I've abbreviated it below, but I can post the entire output on request:</div><div style="font-size:13px"><br></div><div style="font-size:13px"><div>checking for mysql_config... /usr/bin/mysql_config</div><div>checking for MySQL... yes</div><div>...</div><div>GDAL is now configured for x86_64-unknown-linux-gnu</div><div><br></div><div> Installation directory: /usr</div><div> C compiler: gcc -g -O2</div><div> C++ compiler: g++ -g -O2</div><div><br></div><div> LIBTOOL support: yes</div><div> ...</div><div> cURL support (wms/wcs/...):yes</div><div> PostgreSQL support: no</div><div> MySQL support: yes</div><div> ...</div><div> Expat support: no</div><div> libxml2 support: no</div><div> ...</div><div> SQLite support: yes</div><div> PCRE support: no</div><div> SpatiaLite support: yes</div></div><div style="font-size:13px"><br></div><div style="font-size:13px">I would think the "MySQL support: yes" and "checking for MySQL... yes" would be fairly concrete. Additionally, I have scoured the make output, and there were no errors or warnings around any of the MySQl stuff. So, it should work, right? Apparently not:</div><div style="font-size:13px"><br></div><div style="font-size:13px"><div># ogr2ogr --format mysql</div><div>ERROR 1: --format option given with format 'mysql', but that format not</div><div>recognised. Use the --formats option to get a list of available formats,</div><div>and use the short code (ie. GTiff or HFA) as the format identifier.</div></div><div style="font-size:13px"><br></div><div style="font-size:13px"><div># ogr2ogr -f MYSQL MYSQL:"geo,tables=Time_Zone_Polygons" -nln Time_Zone_Polygons -nlt POLYGON \</div><div> -update -append -progress -gt 40000 -fieldmap 2 \</div><div> -lco ENGINE=MYISAM -lco LAUNDER=yes -lco FID=id -lco FID64=TRUE -lco GEOMETRY_NAME=region tz_world.shp</div><div>Unable to find driver `MYSQL'.</div><div>The following drivers are available:</div><div> -> `PCIDSK'</div><div> ... (no MySQL anywhere)</div></div><div style="font-size:13px"><br></div><div style="font-size:13px">Can I get some help/advice figuring out what went wrong?</div><div style="font-size:13px"><br></div><div style="font-size:13px">Thanks,</div><div style="font-size:13px"><br></div><div style="font-size:13px">Nick</div></div>
</blockquote></div><br></div>