将SHP导入MySQL中

时间:2022-04-24 00:14:43

ogr2ogr -f MySQL MySQL:smfs,host=127.0.0.1,user=root,password=gis D:\spatialData\HB\HuBeiPicture\HuBeiPicture\station.shp -nln gis_station_gdal -update -overwrite -lco engine=MYISAM

ogr2ogr -f MySQL MySQL:smfs,host=127.0.0.1,user=root,password=gis D:\spatialData\HB\HuBeiPicture\HuBeiPicture\station.shp -nln gis_station -update -overwrite -lco engine=MYISAM   
       
shp2mysql -c D:\spatialData\HB\HuBeiPicture\HuBeiPicture\station gis_station smfs | mysql smfs -u root -p gis
       
mysql -h 127.0.0.1 -u root -p gis
               
shp2mysql -c D:\spatialData\HB\station\station gis_station smfs | mysql -h 127.0.0.1 -u root -p smfs

shp2mysql -c D:\spatialData\HB\station\station gis_station smfs | mysql -h 127.0.0.1 -u root -p smfs

shp2mysql D:\spatialData\HB\station\station gis_station smfs > gis_station.sql