Upload Shapefile in MySQL as Spatial Data|QGIS|FWTools

This tutorial will explain in detail on how to import shape files into a MySQL database as spatial data using QGIS and FWtools. This tutorial is aimed for both gis specialists and all those who are interested in proper usage of spatial data and handling various tasks in MySQL. This flowchart diagram illustrates the entire process right from the point where you have a Shapefile in QGIS and want to convert it to a format that can be’spatially extended’ in MySQL using FWTools.

You will find out how to use the QGIS login to check the data and FWTools for conversion, the import process to make sure that the spatial data is stored as it should be in MySQL. At the end of this tutorial, one will be in a position to integrate Shape files with MySQL, boosting his/her GIS skills as well as general usability and applicability of spatial data.