New answers tagged mysql
I solved this a week ago. The problem was that I had ACAD Map3D for 64bit and my mysql version was 32 bit so libmysql.dll was 32 bit too.
I do not have to register the mysql dll. Instead, I just copy it into the bin/fdo dir. I do not even have to reboot. I run a lab full of PCs and all I have to do is copy the dll into the folder and off we go.
Postgres postgis is the best solution to store geodata. Many solutions are available: use the nosql because the price is low (amazon or azure), create your index.... Or use fme cloud with kmz streaming it's easy and the price is 1$/h.
ogr2ogr -f MySQL MySQL:test,user=root MSSQLSpatial "MSSQL:server=.\MSSQLSERVER2008;database=geodb;trusted_connection=yes" See the documentation for the syntax http://www.gdal.org/ogr/drv_mysql.html
Both your GDB file and MySQL DB do now have the spatial data -- lon-lat points -- in shape columns, but encoded as binary data. In computing, data types often have different internal and external representations. You wish to see the data presented in lon-lat, but they are represented internally in binary. You just need to use the appropriate function to ...
Thanks Mapperz, the link helped to get a feeling about the status of the spatial plugin. http://www.mysqlperformanceblog.com/2013/10/21/using-the-new-spatial-functions-in-mysql-5-6-for-geo-enabled-applications/
Top 50 recent answers are included