[FWTools] ogr2ogr with MySQL
mateusz at loskot.net
Thu Oct 12 12:27:20 EDT 2006
Frances Collier wrote:
> I am trying to import shape file data into a MySQL database using
> ogr2ogr. I am running on a Windows Server 2003 Standard. When I try to
> run my statement, I get this error: “MySQL driver does not support data
> source creation.” I checked the dlls in the FWTools 1.0.5 bin directory
> and have libmysql.dll there. I’ve googled, and searched through the
> forums, but haven’t found anything pertaining to this problem. Here’s
> the actual statement I’m trying to run: “ogr2ogr –f MySQL
> D:\CountyPopulation\countPop.shp –nln countypop –lco PRECISION=NO”
According to MySQL driver docs:
Currently, MySQL driver does not support database creation.
So, you have to create 'test' database manually first.
Then you can import layers to it.
More information about the FWTools