Dump MySQL Data to CSV with Python

mysql-to-csv.py

# requirement: python-mysqldb

import MySQLdb as dbapi
import sys
import csv

QUERY='SELECT * FROM mydb.people;'
db=dbapi.connect(host='localhost',user='root',passwd='password')

cur=db.cursor()
cur.execute(QUERY)
result=cur.fetchall()

c = csv.writer(open('dbdump01.csv', 'wb'))
for x in result:
    c.writerow(x)

You may also need to add string encoding to the open file writer:
encoding='utf-8'
c = csv.writer(open('user_dump01.csv', 'w',encoding='utf-8'))

result = DB.query('select * from fb')
c = csv.writer(open('dbdump01.csv', 'w'))
for x in result:
c.writerow(x)

This works cool