convert a mysql table to csv

table_to_csv.py

'''
table_to_csv converts a table
db_to_csv converts all the tables
'''

import MySQLdb
import csv

# configure
DB_HOST = 'localhost'
DB_USER = 'xxxxxx'
DB_PASS = 'yyyyyy'
DB_NAME = 'zzzzzz'

# connection & cursor
connection_data = [DB_HOST, DB_USER, DB_PASS, DB_NAME]
conn = MySQLdb.connect(*connection_data)
cur = conn.cursor()

def table_to_csv(table):
    cur.execute('select * from ' +  table)
    f = open(table+'.csv', 'w')
    fw = csv.writer(f)
    fw.writerow([r[0] for r in cur.description])
    fw.writerows(cur.fetchall())
    f.close()

def db_to_csv():
    cur.execute('show tables')
    tables = [t[0] for t in cur.fetchall() ]
    for table in tables:
        table_to_csv(table)