MySQL can product XML output. Just instruct MySQL to return data as XML instead of sql.
Here is how to get XML output from MySQL:
/opt/lampp/bin/mysql -uroot -proot --xml -e "select post_title, post_date,guid, post_content from wt.wp_posts limit 50" > /tmp/posts.xml
Options:
--xml: for xml output
--execute or -e: for executing output.
Can use multiple query inside "". Separate each query with semicolon.
Comments (1)