Hi,

MySQL, being a relational database (quiet, you guys from other camps), is
good at storing relational data.

To store purely XML data, you may be better off using an XML database e.g.
Tomino from Software AG.

The line is a fine one, though. If your XML is purely a representation of
relational data, you may like to look at mysql -X in the latest client,
which, I believe, will produce the results in XML - I haven't tried this.

Regards

Quentin

-----Original Message-----
From: Clive Bredenkamp [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 10 January 2002 2:52 a.m.
To: '[EMAIL PROTECTED]'
Subject: MYSQL : XML storage


Hi All,

I have about 15GB of xml files each ranging from about 400bytes to 4k (some
exceptions being up to a few MB, but mainly small), and am planning to stick
these files in a database for better mainteance. 

Does anyone have advice on the best way in which to import so many files or
any advice on storage structure.

Thanks,
Clive.

~~~~~~~~~~~~~~~~~~~~
CLIVE BREDENKAMP
IT Dev Consultant
L@wyers Access Web
(031) 502 7630
082 3223 988
~~~~~~~~~~~~~~~~~~~~

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended 
recipient, you are asked to respect that confidentiality and not 
disclose, copy or make use of its contents. If received in error 
you are asked to destroy this email and contact the sender immediately. 
Your assistance is appreciated.

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to