[Tfug] mySQL use

[r35157anc3]

Sorry, I made the blind assumption that there would be an import option 
for XML, but it doesn't look like there is. Not even options if you call 
LOAD FILE from mysql. They  (some guys on a mailing list I was just 
reading from) recommend transformation to SQL using XSLT and the Xalan 
transformer.

I'm sorry. Maybe it wasn't such a good idea afterall. Well, not unless 
you like XSLT.

&Leo();

Jim Secan wrote:

>At 09:42 AM 12/23/03 -0700, &Leo(); wrote:
>  
>
>>I would create an ascii db -> XML object binding in Fortran that is 
>>compliant with the MySQL XML database standard. Then I would dump the 
>>database using a fortran dump program written for the binding, and run 
>>the mysqlimport on the outputted XML.
>>    
>>
>
>The mysqlimport doc on the mysql website doesn't show an XML option.  Would
>I need some other tool to make the XML -> mySQL transition?  There is an
>option for mysql output as XML (-X or --xml), but no corresponding one
>(documented) for mysqlimport.
>
>Jim
>*---------------------*-------------------------------*
>| Jim Secan           | Northwest Research Assoc, Inc |
>| (jim at nwra-az.com)   | 2455 E. Speedway, Suite 203   |
>| (520) 319-7773      | Tucson, Arizona 85719         |
>|    Space Weather Info: http://www.nwra-az.com/      |
>*---------------------*-------------------------------*
>_______________________________________________
>tfug mailing list
>tfug at tfug.org
>http://www.tfug.org/mailman/listinfo/tfug
>  
>