up vote -1 down vote favorite

I'm very new to Python. How can we drop and create the database in Python?

I'm using MySql and Windows server 2003.

Note: I have all the queries, Drop, create and insert records everything in a input.sql

So I want to import input.sql.

Can anyone help me?

share|improve this question

1 Answer

up vote 2 down vote

If you have access to the mysql client, then this is trivial:

mysql -u username -p database < input.sql

This will prompt you for a password; if you want to supply the password inline:

mysql -u username -ppassword database < input.sql

Run any of the above from Python using the subprocess module.

The not-so-easy way would be to read each line of the file - do some logic to grab entire SQL statements - and then execute it against the database "manually", but this would just replicate what the mysql command is doing:

import MySQLdb
db = MySQLdb.connect(username="foo",passwd="secret",db="mydb")
c = db.cursor()

with open('input.sql') as f:
   for line in f:
      proper_sql = some_magic_function(line)
      c.execute(proper_sql)
      db.commit()
share|improve this answer
1  
Plus, the not-so-easy way would not work the same, as the default mysql client will detect open brackets etc. and thus allow statements spanning over multiple lines. – Jonas Wielicki Aug 26 '12 at 10:58

Your Answer

 
or
required, but never shown
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.