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)

Answer 1

mysqldump --xml test > test.xml

or

mysqldump -X test > test.xml

mysqldump to xml

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.

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

Answer 4

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

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

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