mysql - execute *.sql file with python MySQLdb

Question

How can execute sql script stored in *.sql file using MySQLdb python driver. I was trying

cursor.execute(file(PATH_TO_FILE).read())

but this doesn't work because cursor.execute can run only one sql command at once. My sql script contains several sql statements instead. Also I was trying

cursor.execute('source %s'%PATH_TO_FILE)

but also with no success.

Answer 1

From python, I start a mysql process to execute the file for me:

from subprocess import Popen, PIPE
process = Popen(['mysql', db, '-u', user, '-p', passwd],
                stdout=PIPE, stdin=PIPE)
output = process.communicate('source ' + filename)[0]