$mysqldump -u user -p --fields-terminated-by=',' --tab=/tmp mydatabase mytable
The above command will create 2 files in /tmp. mytable.sql and mytable.txt. The sql file will contain the table creation schema and the txt file will contain the records of the mytable table with fields delimited by a comma.
Keep in mind that the --tab option will only work if the mysql client and the mysql server are all running on the same machine.
You can omit the 'mytable' part of the command to export all tables in the database, one table per file.