Feb 132008
Export MySQL database as CSV file
Answer:
Export MySQL database CSV file can be done with the mysqldump command.
E.g.
# mysqldump my_db --fields-terminated-by=',' --fields-enclosed-by='"' --fields-escaped-by='\' --lines-terminated-by='\n' --tab /tmp
You will find the whole database my_db is exported under the /tmp folder, in which *.sql files are the table definiation, and *.txt files are the table's content in CSV format.