From LQWiki

mysqldump is a database backup program for SQL-databases that will dump database content in a variety of formats like CSV, ready to run sql-queries and XML.

 mysqldump [options] db_name [tablenames] > mySqlDump.txt
 mysqldump --iuser=myName --password=myPasswd --all-databases --xml > mySqlDump.xml