We help IT Professionals succeed at work.

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
Comment
Watch Question

Top Expert 2015

Commented:
Only PostgreSQL now. All mySQL posts are 5+ years old

Author

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.
Top Expert 2015

Commented:
Yes, and you can run oracle on another port, then DB2, and informix on others...

Author

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.
Top Expert 2015
Commented:
Pros - if you need to make a lot of queries
Cons - it is one sync interval behind.

Author

Commented:
That's it? That works for me, thanks.