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]