Natural Earth » Blog Archive » Topic: Converting for MySQL – Free vector and raster map data at 1:10m, 1:50m, and 1:110m scales
I am having problem with migrating sqlite database of natural_earth_vector.sqlite which you told me to download from the link given to mysql. I have converted sqlite database to mysql using sqlite manager which is full version. Conversion was done successfully but while importing database to mysql, it shows a numerous query errors. @Ronnie, There are several different flavors of SQLite, this file was created using GDAL / OGR, link here: http://www.gdal.org/ogr2ogr.html. Is there a direct SHP file to MySQL tool you can use instead? I’m trying to get him to come on the site and chat with you about this – rather than me being a middle man. It’s like pulling teeth with a pair of tweezers. Many many thanks for the information. Could you please tell me to convert that SQLite database to MySQL database or any specific tool or command. Source.