Mysqldump is a utility that comes with MySQL. It can be used to dump a database or a collection of databases for backup or for exporting the data to another SQL server. The dump contains SQL statements to create the table and/or populate the table.

Here are common ways to invoke mysqldump:

shell> mysqldump [options] db_name [tables]
shell> mysqldump [options] –databases DB1 [DB2 DB3...]
shell> mysqldump [options] –all-databases

shell>mysqldump –all-databases –master-data=2 > all_databases.sql

If you do not name any tables or use the –databases or –all-databases option, entire databases are dumped.

To get a list of the options your version of mysqldump supports, execute

mysqldump –help

There are many ways to export MySQL data. One of them is the SELECT … INTO OUTFILE.
The SELECT … INTO OUTFILE is the complement of LOAD DATA INFILE.
It is used to create a simple delimited file and is intended to let you very quickly dump a table to a text file.

Type the following SQL at the mysql prompt:

SELECT * INTO OUTFILE ‘MyFileName.txt’
FIELDS TERMINATED BY ‘|’
LINES TERMINATED BY ‘\r\n’
FROM mytablename;

Of course, you must have the FILE privilege to create the file on the server host.