Import the SHP file to the MySQL database.

A shp file consists of multiple files

Import the SHP file to the MySQL database and use the shp2mysql Doc command.

First download doshere

/Files/ycsfwhh/import the SHP file to mysqlcommand. rar

1. Put SHP and SHP related files and doshere DOC files in the same directory.
2. The doc command is:
Shp2mysql SHP file name. SHP table name Database Name> generated SQL file name. SQL
3. Modify the generated SQL file:
Alter table table name Add the_geom geometry;
Add must be the_geom Geometry

Replace all,-1 ));
4. Import the SQL file to the MySQL database.
5. Connect Mysql Data in geoserver to display the map