Import Shapefiles in MySQL

[Srushti Abhyankar]

Hi

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...