Re: MySQL import of XML

From: Thomas 'PointedEars' Lahn <PointedEars_at_web.de>
Date: Sat, 18 Jul 2015 19:57:11 +0200
Message-ID: <1564559.7a7C0NnzKs_at_PointedEars.de>


Bjarne Jensen wrote:

> I have converted a pdf to XML - see truncated version:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <!DOCTYPE pdf2xml SYSTEM "pdf2xml.dtd">
> <pdf2xml producer="poppler" version="0.24.1">
> <page number="1" >
> <text top="836" >DatNum</text>
> <text top="836" > 1/53</text>
> […]
>
> mysql> LOAD XML LOCAL INFILE '/home/me/xml/CheckList_MOD_9.xml'
> INTO TABLE clist(number, top, text);
> Query OK, 0 rows affected (0,01 sec)
> Records: 0 Deleted: 0 Skipped: 0 Warnings: 0
>
> No error messages but also no imported data.
>
> What am I doing wrong?

The LOAD XML statement does _not_ import *arbitrary* XML into an MySQL database.

RTFM: <http://dev.mysql.com/doc/refman/5.6/en/load-xml.html>

-- 
PointedEars

Twitter: _at_PointedEars2
Please do not cc me. / Bitte keine Kopien per E-Mail.
Received on Sat Jul 18 2015 - 19:57:11 CEST

Original text of this message