title: Import OpenStreetMap-Data (OSM-File) to a MySQL-Database / SQL-File
body: <h2>Intro</h2>
  <p>I downloaded and extracted the OpenStreetMap Source File (<a href="http://planet.openstreetmap.org/" rel="nofollow noreferrer">See here</a>). I have a 400GB XML-sourcefile now, and i would like to (1) insert the data in a MySQL Table <strong>OR</strong> (2) export this to an SQL file, doesn't matter.</p>
  <h2>What I already did / tried</h2>
  <ol>
  <li>I have the XML File^^ and the MySQL Server (5.6.14)</li>
  <li>I found the tool <a href="http://wiki.openstreetmap.org/wiki/Osmosis" rel="nofollow noreferrer">Osmosis</a>, to convert OSM data and I installed it</li>
  <li>I read this post: <a href="https://stackoverflow.com/questions/14705063/read-cities-and-streets-into-a-database-without-api">Read cities and streets into a database without api</a></li>
  <li>I also read this post: <a href="https://stackoverflow.com/questions/19791495/is-this-config-is-capable-to-import-complete-osm-planet-file">Is this config is capable to import complete osm planet file?</a> (It is.)</li>
  <li>I tried to insert the data with osmosis, but it throws an error after a few seconds, or is doing nothing for hours, without inserting one single row. I also don't understand how this should work, because I don't have the OSM table structure in MySQL.</li>
  </ol>
  <h2>The Question</h2>
  <p>Is it generally possible to import the whole File in a Database / SQL-File, and if yes,  how? Where do I find the table/database-structure? Has anyone already tried?</p>
  <p>Thank you very much!</p>