Mysqldump

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