Export data into the outfile using select statement.
mysql>Select * from tutorials_tbl into OUTFILE ‘/tmp/tutorials.txt’;
‘mysqldump’ is used to copy or back up tables and databases
$mysqldump -u root -p TUTORIALS tutorials_tbl>dump.txt password
$mysqldump -u root -p TUTORIALS > database_dump.txt password ****
$mysqldump -u root -p –all-databases>database_dump.txt password**