Este tipo de respaldo no es una buena práctica para realizar un full backup, pero es ideal para exportar información a excel.
[root@atom tmp]# mysqldump -u root -p --no-create-info
--tab= --fields-terminated-by=, --fields-optionally-enclosed-by=\" morningstar ts_60
more ts_60.txt
1,"2011-12-08 21:23:02",25.2111,0,4.72213,0,0,25.2111,22,25,0,135.4,135.4,130,1,0,0,3,0,3,24.31,29.25
1,"2011-12-08 21:24:01",25.2111,0,4.72213,0,0,25.2111,22,25,0,135.4,135.4,130,1,0,0,3,0,3,24.31,29.25
1,"2011-12-08 21:25:01",25.2081,0,4.72213,0,0,25.2081,22,25,0,135.4,135.4,130,1,0,0,3,0,3,24.31,29.25
1,"2011-12-08 21:26:02",25.214,0,4.72213,0,0,25.1963,22,25,0,135.4,135.4,130,1,0,0,3,0,3,24.31,29.25
1,"2011-12-08 21:27:01",25.2583,0,4.72213,0,0,25.2494,22,25,0,135.4,135.4,130,1,0,0,3,0,3,24.31,29.25
1,"2011-12-08 21:28:02",25.2583,0,4.72213,0,0,25.2583,22,25,0,135.4,135.4,130,1,0,0,3,0,3,24.31,29.25
1,"2011-12-08 21:29:01",25.2583,0,4.72213,0,0,25.2583,22,25,0,135.4,135.4,131,1,0,0,3,0,3,24.31,29.25
1,"2011-12-08 21:30:01",25.2583,0,4.72213,0,0,25.2583,22,25,0,135.4,135.4,131,1,0,0,3,0,3,24.31,29.25
Esto solo funciona para versiones anteriores a MySQL 5.1.38 Otra forma de hacerlo es la siguiente:
SELECT * FROM ts_60
INTO OUTFILE '/tmp/ts_60.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"';