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
projectsAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
projectsAuthor Commented:
That's it? That works for me, thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.