(1) my exporting from mysql command line
mysql> SELECT *
> FROM <table>
> INTO OUTFILE 'file path'
> FIELDS TERMINATED BY '|';
will select all columns from table <table> and save the output into <filename>
example 1:
SELECT * FROM CategoryInformation
INTO OUTFILE 'c:\CategoryInformation.csv'
FIELDS TERMINATED BY ';'
ENCLOSED BY '\"'
ESCAPED BY '\'
LINES TERMINATED BY '\r\n'