[Tfug] mySQL use

[r35157anc3]

Jim,

I didn't think of this earlier because I must be on some kind of XML 
binge, but you can also just make the output in straight SQL and pipe it 
with:

mysql -u <user> <database> < yoursqldump.sql

I like XML though. It's more reusable.

&Leo();

Jim Secan wrote:

>At 09:42 AM 12/23/03 -0700, you 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.
>>    
>>
>
>Excellent idea - I like it.  I'm usually not a fan of the XML overhead, but
>for the temporary interim files they would work nicely.  I've got some Java
>XML and mSQL code floating around that could form the framework for what I
>need.
>
>HoHoHo - and all that.
>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
>  
>