How to convert a MySQL DB to XML?

Question

How can you convert a MySQL database to XML? I want everythimg... data and there relation in XML schema file

how to convert from sqlyog community 8.13(free version)

Lylalyle

Do you mean data from the table? – Debutante

How exactly do you want the data to be formatted? – Tartrate

I want everythimg... data and there relation in XML schema file – Lylalyle

Answer 1

mysqldump --xml test > test.xml

or

mysqldump -X test > test.xml

mysqldump to xml

Robustious

Answer 2

phpMyAdmin has an Export to XML function in it. You could either use that, or examine the code to see how they did it.

Mascle

Answer 3

The command line client that comes with MySQL has a --xml option: http://dev.mysql.com/doc/refman/5.1/en/mysql-command-options.html#option_mysql_xml

If the output format of that does not match what you need, you could just select the data out and concatenate it with your xml tags:

select concat('<field1>',field1,'</field1><field2>',field2,
'</field2>') from table

Tartrate

Answer 4

SQLyog also does a good implementation of exporting data to XML...

Debutante

Right click on table and select "Backup/Export" and choose "Export table data as..." You can choose CSV, HTML, XML, Excel XML or SQL... Very handy – Debutante

Answer 5

For a single table

mysql --xml -u username -p database_name table_name > table_name.xml

For a query

mysql --xml -u username -p database_name -e 'select * from table_name' > query.xml

For the whole database

mysqldump --xml -u username -p database_name > database.xml

Krak

Answer 6

in fact it's actually

mysqldump --xml dbname -t tablename

with eventually -u username -pPASSWORD (or -p for an interactive passwd input) according to your privileges..

Eta