XML : loading XML file into MySQL

I have to get values from XML file.
I tried LOAD XML INFILE.
My XML structure is like following:

  <cli>  <num_id>120</num_id>  <contact>      <nom>DUPOND</nom>      <prenom>Pierre</prenom>  </contact>  <relation>253</relation>  <adresse>      <adresse_c>route de la mer</adresse_c>      <code_postal>64200</code_postal>      <ville>Biarritz</ville>  </adresse>    

How can do? Thank you.