MySQL Forums
Forum List  »  GIS

Import Shapefiles in MySQL
Posted by: Srushti Abhyankar
Date: October 05, 2007 01:04PM


I have few shape files that I need to migrate into MySQL. There has been a related thread on this forum before. I learnt that shp2mysql can be used to do the same.

But I am not getting any success with it. I am new to all this.

I use the following command as mentioned in the Readme.

shp2mysql -c roads1 roads_table my_db
where: roads1 is the name of the shape file
roads_table is the name of the table in MySQL
my_db is the name of the MySQL database (schema) name

When I run the above command in the DOS prompt, a series of insert statements and the like get generated. But when I go to the MySQL Administrator, I dont see any new table that is created.

So my question is: Whether this tool can be used on Windows?
If Yes, then is there something else that I need to do or am I doing something wrong?

Please help me...

Options: ReplyQuote

Written By
Import Shapefiles in MySQL
October 05, 2007 01:04PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.