• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 218
  • Last Modified:

Importing OpenStreet Mysql

I am reading pros and cons about importing the osm database into my own mysql server but since there are so many variations in posts, I thought I would ask here to get the most current version.

I want to have a local osm db so that I don't have to use others bandwidth and to speed up the reads.
I will install the entire db and then only update as needed.

The server already has MySQL installed on it and I am thinking of using it for development and later will likely build a new server for OSM using Postgress or something else. Apparently, geographic extensions are missing when using MySQL, unless that is old information on the wiki?

Cannot afford an optimized service at this time but perhaps in the near future.

Wondering what the pros and cons are as well as what method to use for importing the xml file.

Thanks
0
projects
Asked:
projects
  • 3
  • 3
1 Solution
 
gheistCommented:
Only PostgreSQL now. All mySQL posts are 5+ years old
0
 
projectsAuthor Commented:
Means I would have to run both on the same server for a while then.
That part should not be much of an issue. I think it could run on a different port.
0
 
gheistCommented:
Yes, and you can run oracle on another port, then DB2, and informix on others...
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
projectsAuthor Commented:
So, as far as importing the db, there's plenty of info so now I'm just looking for a better understanding of the pros and cons of having a local db.

Once the main file is downloaded and installed (45GB download, I think some 400GB when decompressed?) you only need increment updates so that's not much of an issue.
0
 
gheistCommented:
Pros - if you need to make a lot of queries
Cons - it is one sync interval behind.
0
 
projectsAuthor Commented:
That's it? That works for me, thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now