Help requiring loading XML data into MySQL v5.0

[Vijit Shah]

Hi,
I am a newbie and I am using v5.0 to load data from XML file.
My XML file is
-------------------------------------------------------------------------------
<movies>
<movie>
<id>1</id>
<imdb_url>http://www.imdb.com/title/tt0389605/</imdb_url>;
<title>Dinosaur Planet</title>
<cast>
<actor>Christian Slater</actor>
<actor>Scott Sampson</actor>
</cast>
</movie>
</movies>
-------------------------------------------------------------------

I am using the following command to load data into MySQL

LOAD DATA INFILE 'path.xml'
INTO TABLE `xyz`
FIELDS TERMINATED BY '\n'
LINES TERMINATED BY '</movie>' ;

I am getting Syntax error in mySQL

Please help me in solving this error or any method by which I can load data from XML file.

Thanks
Vijit