Page 1 of 1
From mySQL to xml....?
Posted: Wed Feb 01, 2006 9:16 am
by gotlisch
Hi,
I'm just wondering if there is any easy way of exporting a MySQL DB to xml?
Cheers
Mikael
Posted: Wed Feb 01, 2006 9:39 am
by wtf
There should be an option in phpmyadmin to allow for saving table data as xml.
Posted: Wed Feb 01, 2006 9:42 am
by raghavan20
In PHPMyadmin under the Export table you have the option to convert to XML. you have to click on a table to generate XML for the table but if you want to generate XML for the entire database, click on the database on the left pane.
Posted: Wed Feb 01, 2006 10:38 am
by gotlisch
Hi guys,
thanks...is there a way of doing it with PHP, so that you don't have to use the admin?
Posted: Sat Feb 04, 2006 4:52 pm
by wtf
My admin would be the easiest way to go. One could always write script to genereate the xml. I'm sure someone else has ran into this before. I'd check phpclasses.org and see what's out there.
Posted: Sat Feb 04, 2006 6:24 pm
by timvw
I once wrote a simple one... But i seem to have removed it from my website...
It's the second link when you search google for rstoxml:
http://www.google.be/search?q=rstoxml&s ... S:official
It seems i've posted it once on devnet too:
http://www.forums.devnetwork.net/viewto ... eece1e3e57.