It is possible dump MySQL database with query command to XML?

Question

It is possible to dump MySQL database programmatically with command or query to XML? Or upload (import) it.

score 1 · Accepted Answer · edited Jun 20 '20 at 09:12

1

Utility mysqldump has a --xml option:

--xml, -X

Write dump output as well-formed XML.

Sample command line:

> mysqldump --xml mydb > mydb.xml

edited Jun 20 '20 at 09:12

Community

answered Nov 22 '19 at 22:50

GMB

So, can I use this command like query command "SELECT * FROM"? – Sahasrar Nov 23 '19 at 07:18
@Sahasrar: no you cannot. This is a command line utility. You might want to have a look at the documentation, which I linked in my answer. – GMB Nov 23 '19 at 10:57
Ok, i will look on it. But, im looking for way how to do it over C# in program. I had an idea to query all records from all table one by one and writing it to xml folder. However, i would like to find smoother way to do it – Sahasrar Nov 23 '19 at 13:31

1 Answers1