1. To export Data out of table into a file.
2. Use field separators and line terminators.
3. To dump a row in binary form into a file.
4. Load data from a file into a table.
5. Create a table from a result set.
6. Copy data into a table from a result set.
7. Using the mysqlimport Utility to Import Data