Export Data in MySQL

 mysqldump -u username -p database_name > database_name.sql

Export a given table:

mysqldump -u username -p database_name table_name > table_name.sql