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 [...]

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 [...]

Suppose you have a data textfile named textfilename.txt that contains 5 comma separated columns of data on each line and each columns enclosed by ‘”‘ (double quotes). You want to import this textfile into your MySQL table named mytablename, which has 5 columns that are named field1, field2, field3, field4 and field5.
To import the datafile, [...]