How to import xml into mysql?

Question

XML

How to prepare xml for import into the structure table of my database
structure itself screen prntscr.com/b2pbai

<report>
<report_name>movies_foreign</report_name>
<generated_at>1462950019</generated_at>
<total_count>14491</total_count>
<movies>
<movie>
<title_ru>007: Координаты «Скайфолл»</title_ru>
<title_en>Skyfall</title_en>
<kinopoisk_id>408871</kinopoisk_id>
<token>4313a2221c5d7df95dde1204733cdc92</token>
<type>movie</type>
<camrip>false</camrip>
<iframe_url>
ссылка на фильм
</iframe_url>
<translator>Дубляж</translator>
<translator_id>21</translator_id>
<added_at>2016-02-28 04:45:38</added_at>
<category/>
</movie>
<movie>
<title_ru>007: СПЕКТР</title_ru>
<title_en>Spectre</title_en>
<kinopoisk_id>678552</kinopoisk_id>
<token>7e5c8fa1cb3760b5</token>
<type>movie</type>
<camrip>false</camrip>
ссылка на фильм
<translator>Дубляж</translator>
<translator_id>21</translator_id>
<added_at>2016-02-28 22:11:38</added_at>
<category/>
</movie>
и так далее примерно 14000 записей
</movies>
</report>

Answer 1

Parsing an XML file with MySQL tools
is not at all, XML is good friends in NoSQL databases
, however, JSON appeared in Muscles and Postgres, where xml is easiest to convert,
study https://dev.mysql.com/doc/refman/5.7/en /json.html and it's up to the easy xml -json converter