As previously mentioned, the mysqldump program is very flexible and supports various types of output, such as the CSV format, which you might use to import data into a spreadsheet, among other purposes. Next example shows how you can dump the data from the classics and customers tables in the publications database to the files classics. In windows server use directory c:/temp. On macOS or Linux systems, you should modify the destination path to an existing folder.

Dumping data to CSV-format files:
mysqldump -u user -ppassword –no-create-info –tab=c:/temp
–fields-terminated-by=’,’ publications