Archive for October 17th, 2008
mysql output csv file
In : mysql, Posted by admin on Oct.10, 2008
Here is the code to output result to csv file.
SELECT order_id,product_name,qty
FROM orders
INTO OUTFILE '/tmp/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
Tags : mysql
sendmail 451 Name server timeout
In : linux, system, Posted by admin on Oct.10, 2008
This is something related to sendmail IPv6 support.
- cd /etc/mail
- sendmail.mc and add the following at the end of the file:
- define(`confBIND_OPTS’, `WorkAroundBrokenAAAA’)dnl
- type make
- restart sendmail
Tags : sendmail