Insert Shapefile in MySql as Spatial Data with the help of ogr2ogr command tool. Mysql supports spatial data type that corresponds OpenGIS insert shapefile.. 2.) Open the command prompt as administrator. I have ogr2ogr file in C drive->OSGeo4W->bin folder., 3.) ogr2ogr –f MySQL MySQL:database_name,host=localhost,user=