13

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)

6 Answers6

19
mysqldump --xml test > test.xml

or

mysqldump -X test > test.xml

mysqldump to xml

Svetlozar Angelov
  • 21,214
  • 6
  • 62
  • 67
8

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

nickf
  • 537,072
  • 198
  • 649
  • 721
4

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
Alterlife
  • 6,557
  • 7
  • 36
  • 49
1

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

Rippo
  • 22,117
  • 14
  • 78
  • 117
  • 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 – Rippo Sep 14 '09 at 09:22
1

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
Kamal Micheal
  • 11
  • 3
0

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

Coornaert David
  • 1
  • 1