Msql Backup/Restore

//Backup Single Database
mysqldump -u username -p example_database > example_database.sql

//Backup Single Table
mysqldump -u username -p database_name table_name > single_table_dump.sql

// Export specific columns from a table to XML
 mysql -u username -p DATABASE --execute='SELECT this,that,other FROM TABLE' -X > FILENAME.xml

//Restore Database
mysql -u username -p database_name < database_name.sql

//Backup Everything
mysqldump -u username -p -x -A > name_of_file.sql