From mySQL to xml....?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
gotlisch
Forum Newbie
Posts: 23
Joined: Wed Jan 11, 2006 8:37 am

From mySQL to xml....?

Post by gotlisch »

Hi,

I'm just wondering if there is any easy way of exporting a MySQL DB to xml?


Cheers

Mikael
User avatar
wtf
Forum Contributor
Posts: 331
Joined: Thu Nov 03, 2005 5:27 pm

Post by wtf »

There should be an option in phpmyadmin to allow for saving table data as xml.
User avatar
raghavan20
DevNet Resident
Posts: 1451
Joined: Sat Jun 11, 2005 6:57 am
Location: London, UK
Contact:

Post 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.
gotlisch
Forum Newbie
Posts: 23
Joined: Wed Jan 11, 2006 8:37 am

Post by gotlisch »

Hi guys,

thanks...is there a way of doing it with PHP, so that you don't have to use the admin?
User avatar
wtf
Forum Contributor
Posts: 331
Joined: Thu Nov 03, 2005 5:27 pm

Post 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.
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post 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.
Post Reply